Updating a table by using if condition - PHP - MySQL

Question

Here am trying to update a field in a table with two values if the value which i got from other file using the GET function is Deactivate update the value of cnf_status as 1 and if it is Activate update the value of cnf_status as 0. But this bit of code is not working...can anyone help me how to solve this issue?

<?php
require_once '../config.php';
$id = $_GET['id'];
$status = $_GET['status'];


if($status == Deactivate)
{

mysql_query("update user_details set cnf_status='1' where user_id = '$id'");
}
else if($status == Activate)
{
mysql_query("update user_details set cnf_status='0' where user_id = '$id'");

}
?>

Whant does 'not working' means? Provide your error

RiaD
– RiaD

2011-08-08 10:01:51 +00:00
Commented Aug 8, 2011 at 10:01 — RiaD
– RiaD, Commented Aug 8, 2011 at 10:01

JK. · Accepted Answer · 2011-08-08 10:02:18Z

1

Forgot quotes maybe?

if($status == "Deactivate")
{
  mysql_query("update user_details set cnf_status='1' where user_id = '$id'");
}
else if($status == "Activate")
{
  mysql_query("update user_details set cnf_status='0' where user_id = '$id'");
}

You should also consider using mysql_real_escape_string() to avoid SQL Injections.

$id = mysql_real_escape_string($_GET['id']);

answered Aug 8, 2011 at 10:02

JK.

5,1261 gold badge29 silver badges26 bronze badges

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

Comments

user409460 · Accepted Answer · 2011-08-08 10:03:35Z

0

Usually you dont use Single quotes for Int fields... try removeing them. You only need them when using with fields like: text, varchar, enum

Also you should quote the Deactivate & Activate otherwise they will be used as constants

answered Aug 8, 2011 at 10:03

user409460

2 Comments

bala Over a year ago

Yeah, i know. Actually i took out the quotes just to get see whether any changes happens. But not changes. Now i tried again by adding quotes, its not working even now

user409460 Over a year ago

you have a mysql connection set up? try this at the end: echo mysql_errno() . ": " . mysql_error() . "\n";

Collectives™ on Stack Overflow

Updating a table by using if condition - PHP - MySQL

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related