i would suggest in your while you do someting like this while($myrow=MySQL_fetch_array($result)) { $time=$myrow["time"];
if ($time =="") {$time ="Sorry No Result"; } echo "$time"; if u get my drift ? ? Nei;l ----- Original Message ----- From: Nathon Jones <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 04, 2002 5:12 PM Subject: [PHP-DB] hiding blank MySQL results? > Hi. > > I have a PHP page calling a set of results from a MySQL database. They > appear in the following format on the results page: > > Title > Description > Link > > Problem I'm having. When a db record has an empty field (for example, no > description), the results page leaves a gap where the description should be. > > How do I do a "hide if empty" thang to stop the gaps appearing? > > Really appreciate the help. > Regards > nathon > [EMAIL PROTECTED] > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]