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]
---------------------------------------------------------------------
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
