Use UPDATE statement

UPDATE tbl SET date_field=NOW() where index=your_index

or

UPDATE tbl SET date_field='2004-04-22' where index=your_index


----- Original Message ----- 
From: "charalambos nicolaou" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 22, 2004 3:35 AM
Subject: [PHP-DB] Inserting data into a table


:Hi everyone,

How can I insert a value in to a field of a MySQL table which is already
NULL but the others in the same row are not.

Also I would like to know if there is a way of inserting in to a DATE filed
the date of the browser.

Thanks in advance.
Charalambos

_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to