check for empty row?

[$php_mysql$]

tried this but it only shows if there are enrty in table if not it would not print no records

 

$sql = mysql_query("SELECT id, image, title, time FROM tbl WHERE post = 'my_dreams' ORDER BY id DESC LIMIT 0,1");
		while($row = mysql_fetch_array($sql)){
                       if(empty($row)){
                        echo "no records";
                        }else{
		echo $row['title']. " - ". $row['id'];
		echo "<br />";
}
}

[radiations3]

did you try this:

    if($row=="")

[$php_mysql$]

yes tried still it would not print no records

[radiations3]

Try to get some help from the following solved issue

:

http://www.phpfreaks.com/forums/index.php?topic=340718.0

[MasterACE14]

$sql = mysql_query("SELECT id, image, title, time FROM tbl WHERE post = 'my_dreams' ORDER BY id DESC LIMIT 0,1");
		while($row = mysql_fetch_array($sql)){
		echo $row['title']. " - ". $row['id'];
		echo "<br />";
}

 

You don't need to check if the '$row' is empty. The results have already been filtered with the query itself.

[$php_mysql$]

but i need to print a no records message if there is nothing in the table, how can i achieve that?

[MasterACE14]

$sql = mysql_query("SELECT id, image, title, time FROM tbl WHERE post = 'my_dreams' ORDER BY id DESC LIMIT 0,1");
   if(mysql_num_rows($sql) > 0) {
		while($row = mysql_fetch_array($sql)){
		echo $row['title']. " - ". $row['id'];
		echo "<br />";
}

} else {
   echo "no records";
}

[$php_mysql$]

thanks soo much that helped :-)