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
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',
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;;
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'
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',
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
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
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
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
='$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
: 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
.
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
12 matches
Mail list logo