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',
> CityID='$CityID',
> CTelephone='$CTelephone',
> Cfax='$Cfax',
> Cemail='$Cemail',
> Caddress='$Caddress',
> Cfax='$CTown',
> Cwww='$Cwww',
> WHERE ItemID='$ItemID'");
> $result = mysql_query($query, $connection) or die("Error with query:
> ".mysql_error()."");
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;";
echo("\n\n$querystring\n\n");
mysql_query($querystring);
will output..
select * from mytable;
You can check the syntax of the command this way.
S.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
