[PHP-DB] Making field concat of autoincrement column and other values?

[Leif K-Brooks]

I'm trying to make a field in my database table a concat of an autoincrement value and some other values. I'm trying:
insert into table set val1='val1',val2='val2',concatfield=concat('whatever',id,'whatever'), but it doesn't work. Is there another way, or will I have to update the row directly after inserting?

--
The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.



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