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

Form validation with functions
Hi there

I am trying to make a very simple form validation function. I currently have the fol

Limiting checkboxes?
Hi guys,

I have this code: Code: if(isset($_POST['selected'])) {
foreach($_POST['selec

dropdown menu
Hello everbody,

I am php newbie.
I need to develop a program that once click the drop do

Timer control causing error
I recently decided to add a timer control to an existing page that uses AJAX on my site. As soon as

Basic Forum Tutorial
Hi, I'm new to PHP. I want to build a basic forum for my site using PHP and MySQL. I've searched t

Problem with a select distinct
I have a problema with a select distinct, I have the next sql:

select distinct a,b,c,d fr

Putting double spaces instead of single spaces
Im looking at trying to replace all single spacing between fields with double spacing

At pres

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see

Getting a variable to work in function params
I have this fuction which is inside a class:

Code: public static function generateEmbedCode($

List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab