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 helpful to output the exact query

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', Category='$Category',

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? snip 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;;

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'

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',

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='$ItemDescription', A

RE: Updat not Updating

2003-03-14 Thread Andrew
: 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,$DBUser,$DBPass); A mysql($DBName,UPDATE items A SET ItemSKU='$ItemSKU', A ItemName='$ItemName', A ItemDescription

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

RE: Updat not Updating

2003-03-14 Thread Andrew
PROTECTED] Sent: 14 March 2003 18:27 To: [EMAIL PROTECTED]; cTpaXo Cc: [EMAIL PROTECTED] Subject: RE: Updat not Updating - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: Updat not Updating

2003-03-14 Thread Paul DuBois
='$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 Updating See note embedded in query above. To spot these things more easily, you might consider assigning

RE: Updat not Updating

2003-03-14 Thread Paul DuBois
: 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? A mysql_connect($DBHost,$DBUser,$DBPass

Re: Updat not Updating

2003-03-14 Thread Brian McCain
. 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:49 AM Subject: RE: Updat not Updating I have an idea why this is but not 100