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
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
