Posted by Gary L. Burnore on 02/03/06 00:16

On Thu, 02 Feb 2006 12:53:17 GMT, "Jim S." <jim@yeah.com> 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
>

Someone already mentioned the howto. May I suggest you try
comp.databases.mysql nex time?

Still trying to spread the word...


--
gburnore at DataBasix dot Com
---------------------------------------------------------------------------
How you look depends on where you go.
---------------------------------------------------------------------------
Gary L. Burnore | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
Official .sig, Accept no substitutes. | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ 0 1 7 2 3 / Ý³Þ 3 7 4 9 3 0 Û³
Black Helicopter Repair Services, Ltd.| Official Proof of Purchase
===========================================================================

[Back to original message]