Help with php5 and mysql

[Ion_Cannon]

Hello, this should be really easy but I am a retard noob to php5 and doing mysql queries.  I am stuck. 

 

Given this query:

 

Db::getInstance()->Execute('UPDATE `'._DB_PREFIX_.'customer` SET `guest`=0

WHERE `email`= $customer->email');

 

How can I get php to insert the value of 0 into "guest" of the customer table if the field "email" matches $customer->email variable within the code.  I can find plenty of examples to match an integer but not a string.

 

Thanks for any help.  Sorry to be such an ubenoob.

 

IC

[dawsba]

I had similar problem with a date set dropping the initial 0, wrap the zero in quotes

 

Db::getInstance()->Execute("UPDATE `"._DB_PREFIX_."customer` SET `guest`='0' WHERE `email`= '".$customer->email."'");

 

[radi8]

not really apropos to the question. 

 

The comparison is exactly like the that for an integer:

$test_email =$_POST['posted_email'];
$val = ($test_email=$customer->email?,0,1);
Db::getInstance()->Execute('UPDATE `'._DB_PREFIX_.'customer` SET `guest`=$val
      WHERE `email`= $customer->email');
// OR
$test_email =$_POST['posted_email'];
if($test_email==$customer->email){
      Db::getInstance()->Execute('UPDATE `'._DB_PREFIX_.'customer` SET `guest`=0
           WHERE `email`= $customer->email');
}