...
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
