Posted by Cliff Smith on 02/03/06 05:22

I would think that
$sql = "update products set smallpicname='$myfile' where id='37'";
would work.

Jim S. wrote:
> 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
>

[Back to original message]