Updating MySQL Error but nothing is wrong in code?

Question

So I get this error:

Problem updating record. MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE KittenID = '2''

But then in my code:

<?php
if(isset($_POST['Modify']))
{	
            $connection = mysql_connect("Deleted the login info");

            // Check connection
            if (!$connection)
	    {
	        echo "Connection failed: " . mysql_connect_error();
	    }
            else
            {
                //select a database
                $dbName="Katz";
                $db_selected = mysql_select_db($dbName, $connection); 
        
                //confirm connection to database
                if (!$db_selected)
                {
                    die ('Can\'t use $dbName : ' . mysql_error());
                }
                else
                {

                $KittenID = $_POST["KittenID"];
				$KittenAge = $_POST['KittenAge'];
				$Name = $_POST['Name'];
				$Email = $_POST['Email'];
				$Gender = $_POST['Gender'];
				$Personality = $_POST['Personality'];
				$Activity = $_POST['Activity'];
				$Comments = $_POST['Comments'];

                $query = "UPDATE Kittenzz 
                          SET KittenID = '$KittenID', 
                              KittenAge = '$KittenAge',
							  Name = '$Name',
							  Email = '$Email',
							  Gender = '$Gender',
							  Personality = '$Personality',
							  Activity = '$Activity',
							  Comments = '$Comments',
                          WHERE KittenID = '$KittenID'";

                $res = mysql_query($query);
                   
                if ($res)
                {
                   echo "<p>Record Updated<p>";
                }   
					else
					{
					   echo "Problem updating record. MySQL Error: " . mysql_error();
					}
				}
            }
            mysql_close($connection);
}
        ?>

It makes no sense, I've read those lines of code for an hour, I cannot see the problem. It should run. Can anyone lend me fresh eyes?

You should never use user input directly in sql queries without at least using an escaping function first, eg mysql_real_escape_string(). Ideally you should not be using mysql_* functions any more for new code as they have been deprecated for years and should instead look at using either mysqli_* functions or PDO — Anigel
– Anigel, Commented Mar 24, 2015 at 8:28

gvgvgvijayan · Accepted Answer · 2015-03-24 04:57:07Z

1

Remove the comma near '$comments'

 $query = "UPDATE Kittenzz 
                          SET KittenID = '$KittenID', 
                              KittenAge = '$KittenAge',
                              Name = '$Name',
                              Email = '$Email',
                              Gender = '$Gender',
                              Personality = '$Personality',
                              Activity = '$Activity',
                              Comments = '$Comments'
                          WHERE KittenID = '$KittenID'";

answered Mar 24, 2015 at 4:57

gvgvgvijayan

2,5051 gold badge25 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sujeet Kumar · Accepted Answer · 2015-03-24 05:09:30Z

0

it may possible that in connection username and password in required. like this :-

$connection = mysql_connect("localhost","username","password");

answered Mar 24, 2015 at 5:09

Sujeet Kumar

1596 bronze badges

1 Comment

Pursuer of Dying Stars Over a year ago

It is, but i deleted that info, in fact the problem was a comma missplaced. Problem solved, see answer up there.

Collectives™ on Stack Overflow

Updating MySQL Error but nothing is wrong in code?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related