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.
Did you know?Explore Trending and Topic pages for more stories like this.
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
No comments posted yet
Your Answer:
Login to answer
199 
35 
Other forums
Quick variable question
hey guys/gals,
im trying to write a php script and it works fine as i have it, but i need to set
Unable to customise toolbar in FCK
Sum of Values in an Array
This is probably really simple... but it's been years since I've written anything, so bare with me!<
Help on query replacing the date
Hi Pals,
i want to replace the current date in a column to some value say C or D or any n
How to show the difference between two data field in a database with php.
Hello php gurus,
how r u all... i'm not so well facing a typical problem please help me...<
Session login issue
I'm wondering how to fix a problem I'm having with a session-based login system
Say I go to h
Problems with strings containing
Hey all,
I have encountered something strange in a script. I am trying to write an XML heade
cURL and Sessions
Ohai.
So, I'm trying to cURL a bunch of things off of a page, and put them into a session. I'
Help with setcookie()
Merry Xmas to those on this foruum
Older guy here with some experience but not allot so please be
Problem Dereferencing
With these types and tables:
CREATE TYPE MANAGER AS OBJECT (
MGR_ID INTEGER,
