Friend I have a Doubt Regarding Queries, that means
I have a Table named : TEST in mysql.
it has some fields like : mobi_deleted,pub_deleted,pdf_deleted ....

according to operation any one of field is updated ....
in my php i got a variable , $var , it's value may be mobi, pub or pdf....

Do I can Write a query like:

UPDATE TEST SET {$var}_deleted = 0;

is this Work properly.... Waoting for ur valuable Reply...

Bye Anes

PHP Code:

$sql = "UPDATE TEST SET {$var}_deleted = 0;"; 


That should work fine provided $var is set to either 'mobi', 'pub', or 'pdf'.

My opinion is:
$table = $var."_deleted";
$sql = "UPDATE TEST SET `".$table."` = 0";
or shortly:
$sql = "UPDATE TEST SET `".$var."_deleted` = 0";