|
|
Posted by Jon on 02/02/06 18:07
Try $sql = "UPDATE products SET smallpicname = '$myfile' WHERE id=37"; -
you're missing the single quotes for string data (which I assume
smallpicname is).
To do the id=idvar it'd be "UPDATE products SET id=$idvar, smallpicname =
'$myfile' WHERE id=37";
"Jim S." <jim@yeah.com> wrote in message
news:1hnEf.4743$Nv2.3807@newsread1.news.atl.earthlink.net...
> hi, i have this
> $sql = "update products set smallpicname = $myfile where id=37";
> mysql_query($sql);
> i want the value of $myfile to be in the $sql , but it is not doing it, so
> what am i doing wrong?
> how can i put variables in the $sql statement so i can execute it with
> mysql_query ???
> since i want also to put .....id= $idvar please help
>
Navigation:
[Reply to this message]
|