If select query doesn't net any results

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux