NamePros.Com - mysql_num

This is a mysql function that allows you to find out how many rows there are in a specific table.

It requires only one parameter which tells it whats the mysql query.

I found it extreemly useful when making a flash and mysql and php driven site.

PHP Code:

   <?php

$link = mysql_connect("localhost", "root", "");//conect to db server

mysql_select_db("haco", $link);//select db

 
$result = mysql_query("SELECT * FROM projects", $link); //select the table

$num_rows = mysql_num_rows($result); //set variable

 
echo "total_rows=$num_rows"; //echo number of rows

 
?>

i hope you find it just as useful to you just like when i first found it.

However if you are looking for executing queries fast I would use:

PHP Code:

   <?php

$link = mysql_connect("localhost", "root", "");//conect to db server

mysql_select_db("haco", $link);//select db

 
$result = mysql_query("SELECT COUNT(*) FROM projects", $link); //select the table

 
echo "total_rows=$result"; //echo number of rows

 
?>

That was a suggestion by NuPagady