yes you are right an I am very stupid for not doing this: It is very important
for debugging as I now have this error :):)
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in
c:\program files\apache
group\apache\htdocs\punterspower\admin\updatecompanyresponse.php on line 23
Error with query: You have an error in your SQL syntax near 'WHERE ItemID='01296
483402'' at line 14
I'm not really happy because I dont know why!!
You didn't read Strahil's hint about missing commas below?
Andrew
>BuFu TeaM mailto:[EMAIL PROTECTED]-----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?
A> mysql_connect("$DBHost","$DBUser","$DBPass"); A> mysql("$DBName","UPDATE items A> SET ItemSKU='$ItemSKU', A> ItemName='$ItemName', A> ItemDescription='$ItemDescription', A> PostCode='$PostCode', A> Category='$Category', A> CityID='$CityID' A> CTelephone='$CTelephone' A> Cfax='$Cfax' A> Cemail='$Cemail' A> Caddress='$Caddress' A> Cfax='$CTown' A> Cwww='$Cwww' A> WHERE ItemID='$ItemID'");
A> Andrew
A> --------------------------------------------------------------------- A> Before posting, please check: A> http://www.mysql.com/manual.php (the manual) A> http://lists.mysql.com/ (the list archive)
A> To request this thread, e-mail <[EMAIL PROTECTED]> A> To unsubscribe, e-mail <[EMAIL PROTECTED]> A> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
There are few simple steps, that everyone should do when using MySQL within PHP. 1. $connection = mysql_connect('host', 'user', 'pass') or die("Error with connect: ".mysql_error().""); 2. mysql_select_db('db_name', $connection) or die("Error with select: ".mysql_error().""); 3. $query = ""; 4. $result = mysql_query($query, $connection) or die("Error with query: ".mysql_error()."");
This steps will provide you information if anything goes wrong and most import where it goes wrong.
From what you wrote, you didn't placed enough commas in the query. Follow the steps described above and paste the error log. www.php.net and www.mysql.com are your friends!
-- best wishes, Strahil Minev a.k.a. DLHelper,
-- Paul DuBois, [EMAIL PROTECTED] http://www.kitebird.com/ sql, query
--------------------------------------------------------------------- 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
