[PHP] PHP Mysql query data conversion newbie

[Andras Kende]

Hello,

I pull some data from mysql with the php code below.
On the date field if there is no date on mysql it displays : 0000-00-00
00:00:00

I would like to change this 0000-00-00 00:00:00 to "no date" for example..

Or if the cel is empty to " " (because otherwise the tableborders are messed
up)

I tried to put an if statement inside the while {} but i cannot figured
out...


Thank You,

Andras



{$aresult=mysql_query("select * from media where d like '$city' order by i"
,$db);}

while($amyrow = mysql_fetch_array($aresult))
        {
          echo "</td><td><font face=verdana size=1>";
                 echo $amyrow["i"];
           echo "</td><td><font face=verdana size=1>";
                 echo $amyrow["j"];
           echo "</td><td><font face=verdana size=1>";
                 echo $amyrow["f"];
           echo "</td>";
        }


-- 
PHP General 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]