Re: default value for date.
| From: | Adam Williams | Date: | Mon, 19 Aug 2002 17:04:26 +0000 |
| Subject: | Re: default value for date. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21234@lists.php.net to get a copy of this message | ||
set a default value that isn't possible (like 9999-99-99 99:99:99) and
then have an if statement saying if ( $row[date] == '9999-99-99 99:99:99'
) { $row[date] = '';}
Adam
On Mon, 19 Aug 2002, Smita Manohar wrote:
> i'm using php with mysql. some tables in database have date fields for which
> i have not set any default value. while displaying the values from tables,
> if any record has null value for date field then it displays 00000-00-00.
> what i need to do to display null value or spaces instead of zeros.
>
> suggestions are welcome.
>
> thnx and regds,
> smita.
>
>
>
> _________________________________________________________________
> Send and receive Hotmail on your mobile device:
> http://mobile.msn.com
>
>
>