test if a db query gets "hit's" 3

[leegold2]

Newbie ques.

I want to be able to test if a db query gets "hit's" or not, so eg,
$query = SELECT * from table...
$result = mysql_query($query)...

Now I assume I would test at some point with:
mysql_num_rows...to see if anything was returned,

Could anyone supply a snippet to show me how?
Thanks

 

[sleipnir214]

You don't need us to supply a snippet. There's one available on the PHP online manual page for mysql_num_rows()


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[leegold2]

Thanks I see it now...

 

[ericbrunson]

If you are not interested in the actual results, then it would be much less resource intensive on the server to do "select count(*) from table where ..." and check the resulting count. Otherwise the server will allocate memory to start returning all those rows that matched.

 

[Olavxxx]

Also, selecting * is the devil in disguise!

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[ingresman]

why's that (in this context) ?

 

[Olavxxx]

I dont know if this is a one-time action, but..

If you select more fields than you have to, performance will suffer.



Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster