-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all I can't work out why this query is also updating a TIMESTAMP col?
UPDATE news SET title = 'new title', text = 'new text' WHERE id = '4' The table is very simple: * id INT * date TIMESTAMP // this is current date when 'updating'? * title VARCHAR * text TEXT I need the date col to remain the same, what am I doing wrong? Much thanks... - -- Nick Wilson // www.explodingnet.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE9CeQ3HpvrrTa6L5oRAp4KAKCeXaGZg7U2GK9HvSvincd+hZytFgCgqG3l YZDx9hSDdpYUPRT0Yj70qc8= =Ne/Y -----END PGP SIGNATURE----- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php