PHP: Delete Specific Column Value From SQL Table

Question

I'm trying to delete a specific column value from an SQL table with php. The table looks like this:

             my_db 
------------------------------------------
 code       | user | email               |
------------------------------------------
 10314343   |  20  | [email protected] |
 13423434   |  22  | [email protected] |
 11342434   |  40  | [email protected] |

What I want to do is update the "code" value to empty on user "20". Here is what I have so far but it's not working:

$tbl_name = mydb;
$getcode = "10314343"


$updateCode = "UPDATE $tbl_name SET code ='', where code ='$getcode'";
$confirmUpdate = mysql_query($updateCode);

sidenote: stop using deprecated mysql_* functions. use MySQLi or PDO instead. Here is a good tutorial for PDO. — Raptor
– Raptor, Commented Apr 28, 2014 at 6:37

Liauchuk Ivan · Accepted Answer · 2015-01-17 12:54:27Z

6

You should delete comma after code=''. This one should work fine:

$updateCode = "UPDATE $tbl_name SET code ='' WHERE code ='$getcode'";

Comma used when you have to update several fields. For example if yo want to update code and email, you should use sql query like this:

$updateCode = "UPDATE $tbl_name SET code ='', email='[email protected]' WHERE code ='$getcode'";

But after last component you should not paste comma

edited Jan 17, 2015 at 12:54

answered Apr 28, 2014 at 6:37

Liauchuk Ivan

2,0233 gold badges14 silver badges22 bronze badges

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

Comments

Noor · Accepted Answer · 2014-04-28 06:41:44Z

1

The comma in your sql statement after code='' is not important. It is very important that you read about sql and understand it, especially its syntax else you might continue to go into these problem and lose time unnecessarily.

answered Apr 28, 2014 at 6:41

Noor

20.3k41 gold badges147 silver badges264 bronze badges

Comments

Lost Koder · Accepted Answer · 2014-04-28 06:42:14Z

0

To make it works remove , from your query.

answered Apr 28, 2014 at 6:42

Lost Koder

90414 silver badges32 bronze badges

Collectives™ on Stack Overflow

PHP: Delete Specific Column Value From SQL Table

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related