/    Sign up×
Community /Pin to ProfileBookmark

Database Won’t accept my numbers

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` SET `StarRating` = 4 AND `Feedback` = ” WHERE `OrderID` = 134774 AND `AccessCode` = ‘WsfdFDASDBascdcwewVV'”

it always going in as 1.

When I force it in via MySQLAdmin it puts ‘ around it.

UPDATE `feedback` SET `StarRating` = ’10’ WHERE `feedback`.`ID` = 5547;

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;
“`

to post a comment
PHP

0Be the first to comment 😎

×

Success!

Help @kiwis spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.7,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...