if (mysql_num_rows($result) < 1) {
//do stuff
}
This is only this easy with mySQL... :-)
<>< Ryan
-----Original Message-----
From: Michael Cortes [mailto:cortesm@fortleboeuf.net]
Sent: Thursday, January 09, 2003 11:07 AM
To: php-db@lists.php.net
Subject: If select query doesn't net any results
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
