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" <npambos@xxxxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Sent: Thursday, April 22, 2004 3:35 AM Subject: 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