On 09-May-01 Jon Haworth wrote:
be sure to check for the NULL :
if (isset($amyrow["date"])) {
>if ($amyrow["date"] == "-00-00 00:00:00") {
> echo "no date";
>} else {
> echo $amyrow["date"];
>}
}
On Sat, 28 Apr 2001, Andras Kende wrote:
> 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 : -00-00
> 00:00:00
>
> I would like to change this -00-00 00:00:00 to "no date" for example..
hmm... mysql can do this,
; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 9:09 AM
Subject: RE: [PHP] PHP Mysql query data conversion newbie
> Well, it's not immediately obvious whether your date is in "i", "j", or
"f",
> so let
t;no date";
} else {
echo $amyrow["date"];
}
echo "";
}
}
HTH
Jon
-Original Message-
From: Andras Kende [mailto:[EMAIL PROTECTED]]
Sent: 28 April 2001 17:01
To: [EMAIL PROTECTED]
Subject: [PHP] PHP Mysql
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 : -00-00
00:00:00
I would like to change this -00-00 00:00:00 to "no date" for example..
Or if the cel is empty to " " (because otherwise the tableborders are messed
up
5 matches
Mail list logo
