loop problem with mysql

[Anon]

Hello I just want a while loop that will count the number of things in my database and print : ex : 8 things on your database

I know the code for the databe and that I will have to use a loop with a $i i++...
But what could be the code of the loop..

Thanks

[Anon]

if you want to count the results of a cerain sql query, you can to the following:

$con = mysql_connect ....
$sql = "select * from sometable";
$result = mysql_db_query("yourdatabase",$sql,$con);
echo $rows = mysql_num_rows($result);

The var $rows will give you the number of rows "selected" by your sql query.

i hope i got your problem right ...

regards

ali

[majik-sheff]

MySQL can return a count if you want.

SELECT COUNT(*) as RowCount FROM MyTable WHERE something = something_else

Will cause MySQL to return a count of the resulting rows filtered by your WHERE clause. Just leave off WHERE if you want a count of the whole table. Ciao!