MySQL Lists are EOL. Please join:

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


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