MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Andrew Date:March 14 2003 5:41pm
Subject:RE: Updat not Updating
View as plain text  
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: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
>
>
>
>---
>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
>

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