populate query from variable???

[tjmcd]

Hi,
Was wondering how I might go about getting a value from a variable (eg. $to_address) into a query???
Something like

function contact_cycle() {   
    $update_cycle =" update contacts set cycle=cycle+1 where $to_address  = contacts.email1;
    $result = $db->query($update_cycle);   
} 

Does that make any sense?

[NogDog]

Since $to_address is presumably a string (not just a number), it will need to be quoted:

$update_cycle = "UPDATE contacts SET cycle = cycle + 1 WHERE email1 = '$to_address'"; 

[tjmcd]

Yes sir'ee BOB that does the trick! The whole thing ended up looking like

function email_cycle_update() {   
    if(!empty($_REQUEST['to_addrs'])) {
        $to_addrs = $_REQUEST['to_addrs'];
    $update_cycle =" update contacts set cycle=cycle+1 where email1= '$to_addrs' ";           
    $db = & PearDatabase::getInstance();   
    $result = $db->query($update_cycle);   
    }} 

but you got it right, and now I do too!
Thank ye kindly!