MasterKaos
Programmer
I'm sure this is something painfully simple, but i can't for the life of me work out what's wrong here:
gives me the error:
The field names must be correct, as i'm using PHP's mysql_field_name() function to retrieve them from the table.
What's wrong here? (i'm sure i'll be embarassed at how obvious it is, but i tried, honest i tried!)
----------------------------------------------------------------------------
The first 90% of the code accounts for the first 90% of the development time. The remaining 10% of the code accounts for the other 90% of the development time.
Code:
UPDATE orders
SET `AmountCents` = '55500',
SET `CourseCode` = '2VIC404',
SET `Name` = 'Joe Bloggs',
SET `Address` = '3/123 Sunny Lane',
SET `City` = 'North Somehwere',
SET `Post_Code` = '1234',
SET `Physiotherapy_Association` = 'apa',
SET `Registration_Number` = 'REG666',
SET `Practice/Hospital` = 'United Nurses Inc',
SET `Phone_(BH)` = '0391194567',
SET `Phone_(AH)` = '0312345678',
SET `Facsimile` = '0388889999',
SET `Email` = 'joe@bloggs.com'
WHERE order_ref = '10202'
Code:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'set `CourseCode` = '2VIC404', set `Name` = 'Joe Bloggs', set `A
The field names must be correct, as i'm using PHP's mysql_field_name() function to retrieve them from the table.
What's wrong here? (i'm sure i'll be embarassed at how obvious it is, but i tried, honest i tried!)
----------------------------------------------------------------------------
The first 90% of the code accounts for the first 90% of the development time. The remaining 10% of the code accounts for the other 90% of the development time.