cannot update the db with below query. little help will be much aprreicated. Thanks in advacne
$order_number=$_GET['order_number'];
$invoice_id=$_GET['invoice_id'];
$credit_card_processed=$_GET['credit_card_processed'];
$total=$_GET['total'];
$key=$_GET['key'];
$email=$_GET['email'];
$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";
Jump to PostYou 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.
Jump to PostSee here how to check for errors:
https://www.daniweb.com/web-development/php/code/434415/using-phpmysql-with-error-checking
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.
See here how to check for errors:
https://www.daniweb.com/web-development/php/code/434415/using-phpmysql-with-error-checking
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...
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.