cannot update the db with below query. little help will be much aprreicated. Thanks in advacne

 $query = "UPDATE register_users SET order_number=$order_number, invoice_id=$invoice_id, 
 credit_card_processed=$credit_card_processed, total=$total, key=$key WHERE email=$email";

You are missing single quotes around the varchar columns. It would be best to add some error checking, so these kinds of mistakes are easily spotted.

sorry using below syntax for query
$query = "UPDATE register_users SET order_number='$order_number', invoice_id='$invoice_id',
credit_card_processed='$credit_card_processed', total='$total', key='$key' WHERE email='$email'";

i had used single quotes still only. was trying other iterations so copy pasted wrong syntax

pls guide.

paste the error would be very helpful

Reasons may be..

incorrect table name or column names or you would have misspelled them. Missing quotes also creates error. as janissantony said, post your error so we can figure it out...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.