Update SQL Row with PHP code

Question

I want to update a row in my database. There is only one row in this database no other rows will be added at this stage.

I am using this PHP code but it does not update the value gives me error:

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 '(credits) VALUES ('')' at line 1

This is my code

 <?php
 $con = mysql_connect("localhost","stingin_epanic","****");
 if (!$con)
   {
   die('Could not connect: ' . mysql_error());
   }

  mysql_select_db("stingin_epanic", $con);

  $sql="UPDATE avis_credits (credits)
  VALUES
 ('$_UPDATE[credits]')";

  if (!mysql_query($sql,$con))
   {
   die('Error: ' . mysql_error());
   }
 echo "Number added thank you";

 mysql_close($con);

 ?>

I know it is something Stupid But Really battelling here

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — Naftali
– Naftali, Commented Jul 30, 2013 at 16:06
Exactly where is $_UPDATE defined? That's no a standard PHP superglobal... — Marc B
– Marc B, Commented Jul 30, 2013 at 16:09

Tobias Golbs · Accepted Answer · 2013-07-30 16:06:17Z

2

Have a look at the UPDATE syntax in mysql.

UPDATE avis_credits SET credits = 'your_value'

WATCH OUT

Please do not use the mysql_* functions anymore. Switch to the mysqli_ functions or PDO. The mysql_ - functions are deprecated and won't be supported >= PHP 5.5.

answered Jul 30, 2013 at 16:06

Tobias Golbs

4,6164 gold badges31 silver badges50 bronze badges

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

Comments

Jakub · Accepted Answer · 2013-07-30 16:06:21Z

0

Echo out your $sql and see what it looks like. My guess is that the values are simply empty based on the error being shown, always do a quick debug.

answered Jul 30, 2013 at 16:06

Jakub

20.5k8 gold badges67 silver badges93 bronze badges

1 Comment

Jakub Over a year ago

@TobiasKun that too, but at least debug and see what it looks like to learn how to fix a SQL error.

Halfstop · Accepted Answer · 2013-07-30 16:07:55Z

0

You shouldn't be using deprecated mysql_* functions.

Your SQL is not correct.

"UPDATE avis_credits set credits = '$_UPDATE[credits]'";

If you can use PDO or mysqli.

answered Jul 30, 2013 at 16:07

Halfstop

1,7821 gold badge20 silver badges38 bronze badges

Comments

Your Common Sense · Accepted Answer · 2013-07-30 16:11:06Z

0

<?php
$dsn = "mysql:host=localhost;dbname=stingin_epanic;charset=utf8";
$opt = array(
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
);
$pdo = new PDO($dsn,'stingin_epanic','', $opt);

$sql = "UPDATE avis_credits SET credits = ? WHERE some_id = ?";
$stm = $pdo->prepare($sql);
$stm->execute(array($_POST['credits'], $_POST['id']));

Assuming you have $_POST, not whatever $_UPDATE

Note the WHERE part. With UPDATE query you have to always use it to address a row to change, mind you

answered Jul 30, 2013 at 16:11

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

Collectives™ on Stack Overflow

Update SQL Row with PHP code

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related