Can not see what is wrong with query anyone see the problem ???

I am sure the query looks right but its not and just cannot see the problem when running the code.
thanks for looking and any help.

[php]
$insert = mysql_query(" UPDATE images_p SET image_path = ‘$md5file’, image_size = ‘$filesize’, filename = ‘$fullImage’, date = strtotime(‘now’), md5 = ‘$md5’ WHERE id = ‘$result[$i][‘code’]’ ") or die (’

MySQL Querry Not Correct highPic update 1 ‘.$md5file.’ — ‘.$filesize.’ — ‘.$fullImage.’ — ‘.strtotime(‘now’).’ — ‘.$md5.’ — ‘.$result[$i][‘productcode’].’

');
[/php]

Results from running the query

MySQL Querry Not Correct highPic update 1
./images/P/p3851095.jpg

25642

p3851095.jpg

1308999305

c1627cbacf8ba33a2b4e2f650ec910e7

3311

feilds from the table images_p I am trying to update.

image_path
image_size
filename
date
md5

Sorted it out myself still do not know whay it was not working but changed the timestamp to a var and it is workign now.

[php]
$insert = mysql_query("
UPDATE images_pSETimage_path=’".$md5file."’,
image_size=’".$filesize."’,
filename=’".$fullImage."’,
date= ‘".$timeStamp."’,
md5=’".$md5."’
WHEREid= ‘".$result[$i][‘productcode’]."’ LIMIT 1 ") or die (’

MySQL Querry Not Correct highPic update 1 ‘.$md5file.’ — ‘.$filesize.’ — ‘.$fullImage.’ — ‘.strtotime(‘now’).’ — ‘.$md5.’ — ‘.$result[$i][‘productcode’].’

');

[/php]

Sponsor our Newsletter | Privacy Policy | Terms of Service