I’m either staring at the issue and can’t see it or something weird is going on
Here’s my table structure.
Here’s my SQL string
“UPDATE `feedback`StarRating`Feedback`OrderID`AccessCode
it always going in as 1.
When I force it in via MySQLAdmin it puts ‘ around it.
UPDATE `feedback`StarRating`feedback`ID
HELP!
“`
CREATE TABLE `feedback` (
`ID` int(10) NOT NULL,
`AccessCode` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`OrderID` int(10) NOT NULL,
`StarRating` tinyint(10) NOT NULL DEFAULT ‘0’,
`Feedback` text COLLATE utf8_unicode_ci NOT NULL,
`TimeSent` int(50) DEFAULT NULL,
`SendCount` int(2) NOT NULL DEFAULT ‘0’
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;