Re: Updat not Updating

2003-03-15 Thread Don Read
On 15-Mar-2003 Sime wrote: > Andrew wrote: >> can you explain how I would do this tracking? >> > > Hi Andrew, > > Try building the query to a variable first, then output the variable to > see > if what MySQL is receiving is what you expected.. > > eg, > $querystring="select * from mytable;";

Re: Updat not Updating

2003-03-15 Thread Sime
Andrew wrote: > can you explain how I would do this tracking? > > My code looks exactly like this: > > mysql_connect("$DBHost","$DBUser","$DBPass"); > mysql("$DBName","UPDATE items > SET ItemSKU='$ItemSKU', > ItemName='$ItemName', > ItemDescription='$ItemDescription', > PostCode='$PostCode', > Cate

RE: Updat not Updating

2003-03-15 Thread Andrew
can you explain how I would do this tracking? Andrew >Subject: Re: Updat not Updating > > >If this is really exactly what your code looks like, you've got an >extraneous comma after the Cwww line. But when you're tracking down a bug >like this, you may find it helpf

Re: Updat not Updating

2003-03-14 Thread Brian McCain
27;re inserting. Brian McCain - Original Message - From: "Andrew" <[EMAIL PROTECTED]> To: "Paul DuBois" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "cTpaXo" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 10:4

RE: Updat not Updating

2003-03-14 Thread Paul DuBois
ew -Original Message- From: nobody [mailto:[EMAIL PROTECTED] Sent: 14 March 2003 17:31 To: Andrew Cc: [EMAIL PROTECTED] Subject: Re: Updat not Updating Hello Andrew, Friday, March 14, 2003, 6:18:15 PM, you wrote: A> Can anyone tell me why this is not updating records for this table

RE: Updat not Updating

2003-03-14 Thread Paul DuBois
x27;, Caddress='$Caddress', Cfax='$CTown', Cwww='$Cwww', <-- no comma here! WHERE ItemID='$ItemID'"); Andrew -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: 14 March 2003 18:27 To: [EMAIL PROTEC

RE: Updat not Updating

2003-03-14 Thread Andrew
, Cfax='$CTown', Cwww='$Cwww', WHERE ItemID='$ItemID'"); Andrew >-Original Message- >From: Paul DuBois [mailto:[EMAIL PROTECTED] >Sent: 14 March 2003 18:27 >To: [EMAIL PROTECTED]; cTpaXo >Cc: [EMAIL PROTECTED] >Subject: RE: Updat not U

Re[2]: Updat not Updating

2003-03-14 Thread nobody
Hello Andrew, Friday, March 14, 2003, 7:41:56 PM, you wrote: A> yes you are right an I am very stupid for not doing this: It is very important A> for debugging as I now have this error :):) A> Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in A> c:\program files\ap

RE: Updat not Updating

2003-03-14 Thread Andrew
>To: Andrew >Cc: [EMAIL PROTECTED] >Subject: Re: Updat not Updating > > >Hello Andrew, > >Friday, March 14, 2003, 6:18:15 PM, you wrote: > > >A> Can anyone tell me why this is not updating records for this table? > >A> mysql_connect("$DBHost","$

Re: Updat not Updating

2003-03-14 Thread nobody
Hello Andrew, Friday, March 14, 2003, 6:18:15 PM, you wrote: A> Can anyone tell me why this is not updating records for this table? A> mysql_connect("$DBHost","$DBUser","$DBPass"); A> mysql("$DBName","UPDATE items A> SET ItemSKU='$ItemSKU', A> ItemName='$ItemName', A> ItemDescription='$ItemDesc

Re: Updat not Updating

2003-03-14 Thread Paul DuBois
At 16:18 + 3/14/03, Andrew wrote: Can anyone tell me why this is not updating records for this table? mysql_connect("$DBHost","$DBUser","$DBPass"); mysql("$DBName","UPDATE items SET ItemSKU='$ItemSKU', ItemName='$ItemName', ItemDescription='$ItemDescription', PostCode='$PostCode', Category='$C

Updat not Updating

2003-03-14 Thread Andrew
Can anyone tell me why this is not updating records for this table? mysql_connect("$DBHost","$DBUser","$DBPass"); mysql("$DBName","UPDATE items SET ItemSKU='$ItemSKU', ItemName='$ItemName', ItemDescription='$ItemDescription', PostCode='$PostCode', Category='$Category', CityID='$CityID' CTelephone