Number of Records Found

[Anon]

Is there a way to do a assign a variable the number of records a SQL query found? I want to take this number and create a loop that displays each record in a drop down option box. None of the documentation I have explains this well enough. Any ideas? Sorry, I'm new to PHP.

[Anon]

if you are using mySQL, then following will return the number of rows (records found):

mysql_num_rows($SQL);

where $SQL is your executed SQL query. i think other db's also use the same format. e.g. for miniSQL its msql_num_rows() or for PostGres its pg_num_rows()...

hope this gets you going...

Daarius...
(note: look at php.net it has quite a useful documentation)

[Anon]

Thanks!