Re: If select query doesn't net any results

... if ($result) { while ($row... ... } $result will be 0 (false) if nothing satisfies the query. Any other comparison is just extra typing with no improvement in logic. Regards, Doug On Thu, 09 Jan 2003 13:06:51 -0500, Michael Cortes wrote: >I am a programming novice and just created my first php application. However I have a situation >I >don't know the answer to. > > >My db queries (mysql) are written like this: > > $qtrans= "select * from $table where (conditionals) order by some field"; > > $link=mysql_connect ($host, $user, $password); > > $result=mysql_db_query($dbname, $qtrans, $link); > > while ($row = mysql_fetch_array($result)) { > > do stuff with the array here > > } > > > >I would like to created an if statement that only occurs if the query gets a result. If there >are >no records that meet the query conditionals and my array ends up with null, I do not want my if >statement to take place. > >Is this easy enough to do? Any help would be great. > >Thank you, > > > > >Michael Cortes >Fort LeBoeuf School District >34 East 9th Street >PO Box 810 >Waterford PA 16411-0810 >814.796.4795 >Fax1 814.796.3358 >Fax2 978-389-1258