var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
This is probably easy, but I can't figure it out, so help will really be appreciated.
I am trying to set all empty last_comment_time field in my table to the same value as image_date (another field). What SQL query do I use?
This didn't work:
Thank you all
update set last_comment_time = image_date where last_comment_time=0
I think you need to set the table name. Also, `image_date` will not work unless you do a join. (assuming you copy/pasted the code)
update `table` set `last_comment_time` = image_date where `last_comment_time` = 0;
How should I join it then?
I'd do two separate queries.
$query1 = mysql_select_assoc(mysql_query(QUERY));
$query2 = mysql_query('update `table` set `last_comment_time` = "'.$query1['image_date'].'" where `last_comment_time` = 0;');