mysql UPDATE request not working and driving me crazy!!!

Posted on 16th Feb 2014 07:03 pm by admin

Hi,

I have been stuck on this for ages.

Quite simply I am trying to update my database with an update command:

Code: $query="UPDATE `spence13_Portfolio`.`skillsList` SET `skillName` = '$newSkillName' WHERE `skillsList`.`ID` =$id";

This doesn't work even though if I change the line to read:

Code: $query="UPDATE `spence13_Portfolio`.`skillsList` SET `skillName` = '$newSkillName' WHERE `skillsList`.`ID` =7";

..then it does work. The variable $id does equal a number and I even use this code to convert it to an integer just incase it's read as a string:

Code: $id = $_POST[skillsListDropDown]; //this is say 7
$id = ((int)$id);

Can anyone please help me.

Thanks

Your Answer:

Login to answer

Other forums

Display Database
I need to create a shopping cart. I found this code online: http://conceptlogic.com/jcart/
Unfort

frames get header location..
i have two frames, one top, one bottom. how do i do a form on the bottom frame that gives me the ur

Production of mango in processing industry
Hi,

We have one scenario ,company is in process industry,they are manufacturing MANGO pul

header redirect problems? please help
Ok i am making a site that generates youtube thumbnails and i am generating an image that displays 1

CHMOD script
Hi,

I need a script to read all files in a folder and set to 777.

Can anyone help out

fopen() security
As i understood the usage of fopen() for it to function correctly the Dir you write to has to be rw

update post issues
I am trying to create an update to a post function, while the update does occur, the page routing an

dynamic table with forms
I have a table that is populated with mysql data and in teh first column there is a raido button tha

user administration
Dear @all,

what I have to do to set the user defaults for new users. At the moment I woul

DATEDIFF Question
First time post, and of course it is a help question.

I am using a WP plug-in to display prev