List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 14 2003 6:26pm
Subject:RE: Updat not Updating
View as plain text  
At 17:41 +0000 3/14/03, Andrew wrote:
>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
>
>>-----Original Message-----
>>From: nobody [mailto:dlh@stripped]
>>Sent: 14 March 2003 17:31
>>To: Andrew
>>Cc: mysql@stripped
>>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 <mysql-thread134731@stripped>
>>A> To unsubscribe, e-mail
> <mysql-unsubscribe-dlh=varna.net@stripped>
>>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:dlh@stripped


-- 
Paul DuBois, paul@stripped
http://www.kitebird.com/
sql, query
Thread
Updat not UpdatingAndrew14 Mar
  • Re: Updat not UpdatingPaul DuBois14 Mar
  • Re: Updat not Updatingnobody14 Mar
    • RE: Updat not UpdatingAndrew14 Mar
      • Re[2]: Updat not Updatingnobody14 Mar
      • RE: Updat not UpdatingPaul DuBois14 Mar
        • RE: Updat not UpdatingAndrew14 Mar
          • RE: Updat not UpdatingPaul DuBois14 Mar
          • Re: Updat not UpdatingBrian McCain14 Mar
            • RE: Updat not UpdatingAndrew15 Mar
              • Re: Updat not UpdatingSime15 Mar
                • Re: Updat not UpdatingDon Read16 Mar