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!! Andrew >-----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, >BuFu TeaM mailto:[EMAIL PROTECTED] > > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.461 / Virus Database: 260 - Release Date: 10/03/2003 > --------------------------------------------------------------------- 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
