Posted by Jim S. on 02/03/06 03:58

rich, i tried what u suggested and it did not work. can u refresh my mind
and tell me, when should i use " and when should i use ' ???
thanks
Jim

"Rich" <rich@newsguy.com> wrote in message
news:drtlrr018v6@drn.newsguy.com...
> In article <manEf.9365$rH5.5246@newsread2.news.atl.earthlink.net>, Jim S.
> says...
>>
>>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
>>
>>
>
> Might try this instead...
>
> $sql = "update products set smallpicname = " . $myfile . " where id=37";
>
> Rich
> --
> Newsguy BonusBytes! - Free monthly rewards
> http://newsguy.com/bonusbytes.htm
>

[Back to original message]