UPDATE database with PHP - not working

Question

My goal is to change the value in the "commission" column from 'open' to 'closed' when I update the table 'status'.I can't seem to get the DB to update. I do not get any errors. What am I doing wrong?

This is the code for my submit button:

if($result["commissions"]=='open'){
    echo '<form method="post" action="admin_main.php">
    <input name="commissionsC" type="submit" value="Close comissions" />
    </form>';
    }

This is the part of my code that is not working:

<?php 
include("includes/connect.php");
if(isset($_POST['comissionsC'])){ 

$res= mysql_query("SELECT * FROM status");
$row= mysql_fetch_array($res);
$sql="UPDATE status".
"SET commissions = 'closed'".
"WHERE id = 1";
}

?>

You don't seem to execute the UPDATE statement in your code. — Fluffeh
– Fluffeh, Commented Apr 5, 2014 at 12:36
Consult my answer @CathrineRydning => stackoverflow.com/a/22881505 — Funk Forty Niner
– Funk Forty Niner, Commented Apr 5, 2014 at 13:31

Funk Forty Niner · Accepted Answer · 2014-04-05 13:27:10Z

1

Change your query to:

$sql = mysql_query("UPDATE status SET commisions = 'closed' WHERE id = 1");

You're not executing your query.

Footnotes:

mysql_* functions deprecation notice:

http://www.php.net/manual/en/intro.mysql.php

This extension is deprecated as of PHP 5.5.0, and is not recommended for writing new code as it will be removed in the future. Instead, either the mysqli or PDO_MySQL extension should be used. See also the MySQL API Overview for further help while choosing a MySQL API.

These functions allow you to access MySQL database servers. More information about MySQL can be found at » http://www.mysql.com/.

Documentation for MySQL can be found at » http://dev.mysql.com/doc/.

answered Apr 5, 2014 at 13:27

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

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

1 Comment

Funk Forty Niner Over a year ago

You're welcome Cathrine. If my answer did solve it, consider clicking the White (gray outline) tick/checkmark till it turns Green next to my answer to mark as answered. Otherwise, your question will remain in the unanswered category. @CathrineRydning

ulaaaan · Accepted Answer · 2014-04-05 13:26:03Z

0

is it always id number 1 that you want to update? Maybe you have to get the number id for each data :

$sql = mysql_query(UPDATE status SET commisions = "closed" WHERE id = 1)

edited Apr 5, 2014 at 13:26

answered Apr 5, 2014 at 12:41

ulaaaan

761 silver badge10 bronze badges

2 Comments

Cathrine Rydning Over a year ago

It is always ID number 1 I want :)

ulaaaan Over a year ago

if that so.. WHERE id = 1 because as I know, if the data is number, it doesn't need use ' '.

Abhinav · Accepted Answer · 2014-04-05 13:26:38Z

0

Once u get the datas, execute the update query as well

$res= mysql_query("SELECT * FROM status");
$row= mysql_fetch_array($res);

$sql = mysql_query(UPDATE status SET commisions = "closed" WHERE id = 1)

edited Apr 5, 2014 at 13:26

answered Apr 5, 2014 at 12:42

Abhinav

8,17812 gold badges51 silver badges92 bronze badges

1 Comment

Funk Forty Niner Over a year ago

Your answer will fail. It should be $sql = mysql_query("UPDATE status SET commisions = 'closed' WHERE id = '$id'") if anything. However OP wants it to be id=1

Collectives™ on Stack Overflow

UPDATE database with PHP - not working

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related