PHP-SQL

gabstlee · January 6th, 2008, 03:18 AM

Hi,
I have a script with title(In html code) and sql queries in a table which works but my problem is "When the query has non results from the DB, the title appears without any results. I would like to have a script which writes a title only when there is a result in the DB.
(Code with Table Field title and result)

gabby

sdi126 · January 8th, 2008, 07:48 PM

You can try checking for nothing with

Code:

if(trim($variable) !=''){
//do title stuff
}

or check the number of rows returned

Code:

$query = mysql_query("select * from table");
if(mysql_num_rows($query) > 0){
//do title stuff
}

http://mynameissteve.com

gabstlee · January 11th, 2008, 12:45 AM

Thank you steve. I will try it today and inform you

gabby