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;";
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
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
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
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
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
,
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
>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","$
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
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
10 matches
Mail list logo
