mysql update query

[dootch]

I forgot to add an image column to my db I just want it to be vendor_id.jpg I figure its something close to this but I cant get it. [code]UPDATE `products` SET `image` = vendor_id,'.jpg' [/code]

Help please

[ToonMariner]

If you have phpmyadmin then just go in and add your column with that file as teh default value.

If you HAVE to do it through php then..

$query = mysql_query("ALTER TABLE `image` ADD `im` VARCHAR( 255 ) DEFAULT 'image.jpg' NOT NULL ");

now varchar limits you to 255 characters - if you need more then use teh text datatype; NOTE you cannot set a default value for text type so you will have to do and extra update after.

PS if that fails it will be down to the privilages you have on teh database

[dootch]

Thanks Solved [code]UPDATE products SET image = CONCAT(product_sku, '.jpg ')[/code]