Update - Agh

[90Nz0]

For the life of me I can't work out what's wrong with the following SQL statment

Table
CREATE TABLE mbProd (
pID int(5) unsigned zerofill NOT NULL auto_increment,
pPartNo varchar(255) NOT NULL default '',
pDesc text NOT NULL,
pManu varchar(255) NOT NULL default '',
pCon varchar(255) NOT NULL default '',
pQty varchar(255) NOT NULL default '',
pPrice float NOT NULL default '0',
pCompID int(5) unsigned zerofill NOT NULL default '00000',
pDate datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (pID)
) TYPE=MyISAM;

Insert Statment
UPDATE mbProd
SET pPartNo = 'NXQ',
SET pDesc = 'Speekers ',
SET pManu = 'Creative',
SET pCon = 'obn',
SET pQty = '5',
SET pPrice = '15.00 ',
SET pDate = now()
WHERE pID = '00030'

Error
You have an error in your SQL syntax near 'SET pDesc = 'Speekers ',
SET pManu = 'Creative',
SET pCon = 'obn',
SET ' at line 4

[bastien]

integers don;t need quotes - so remove quotes from:
pID
pPrice

consider changing pQty to INT as it is a number, then remember to remove the quotes

also note that fieldnames do NOT require quotes - remove them

[90Nz0]

I've done the following changes, but it still does'nt work 🙁

TABLE
CREATE TABLE mbProd (
pID int(5) unsigned zerofill NOT NULL auto_increment,
pPartNo varchar(255) NOT NULL default '',
pDesc text NOT NULL,
pManu varchar(255) NOT NULL default '',
pCon varchar(255) NOT NULL default '',
pQty int(11) NOT NULL default '0',
pPrice float NOT NULL default '0',
pCompID int(5) unsigned zerofill NOT NULL default '00000',
pDate datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (pID)
) TYPE=MyISAM;

SQL:
UPDATE mbProd
SET pPartNo = NXQ,
SET pDesc = 'Speekers ',
SET pManu = 'Creative',
SET pCon = 'obn',
SET pQty = 5,
SET pPrice = 15.00 ,
SET pDate = now()
WHERE pID = 00030

mysql_error:
You have an error in your SQL syntax near 'SET pDesc = 'Speekers ',
SET pManu = 'Creative',
SET pCon = 'obn',
SET pQty =' at line 4

[Lars_Berg]

Yo

UPDATE mbProd
SET pPartNo = 'NXQ',
pDesc = 'Speekers ',
pManu = 'Creative',
pCon = 'obn',
pQty = 5,
pPrice = 15.00 ,
pDate = now()
WHERE pID = 00030 

[90Nz0]

Mate, I could kiss you.... Now the error is...

SQL
UPDATE mbProd
SET pPartNo = 'HP123b',
pDesc = 'HP 123, P4 5Ghz ',
pManu = 'HP',
pCon = 'obn',
pQty = 1,
pPrice = 3,000.00 ,
pDate = now()
WHERE pID = 00037

MySQL_Error

You have an error in your SQL syntax near '000.00 ,
pDate = now()
WHERE pID = 00037

' at line 8

<edit>
Sorted, I was trying to insert 3,000.00 into a float.

$price_2_update = "3,000" ; // The var
$price_2_update = str_replace(",", "",$price_2_update );

</edit>