[Resolved] Get resultcount from sql query

[Hotkey]

Hi!

Is there a way to get the result count from a mysql result set in PHP without submitting an additional COUNT query ?
Eg :
$res=mysql_query("SELECT * FROM sometable");

actually i get the result count with an additional query :
$resCount=mysql_query("SELECT COUNT(*) FROM sometable");

is there a way to avoid the second query ?

Thanks in advance

Hotkey

[tsinka]

Hi,

there's a php function called mysql_num_rows(). You can use that one on a result to determine the number of rows.

Thomas

[Hotkey]

just found it on php.net - next time i'll do some more search before posting.
Thanks anyway !