| SQLdumpster.com Name: Unknown Location: West Sussex, UK Join Date: Jun 2005
Posts: 543
NP$: 108.00 ( Donate)
| Thanks, very useful. There are a few errors in the following, I believe but I may be wrong: PHP Code: $qry = "INSERT into psales (
invoice, receiver_email, item_name, item_number, quantity, payment_status, pendi ng_reason, payment_date, payment_gross, payment_fee, txn_id, txn_type, first_nam e, last_name, address_street, address_city, address_state, address_zip, address_ country, address_status, payer_email, payer_status, payment_type, notify_version , verify_sign )
VALUES
( \"$invoice\", \"$receiver_email\", \"$item_name\", \"$item_number\", \"$quanti ty\", \"$payment_status\", \"$pending_reason\", \"$payment_date\", \"$payment_gr oss\", \"$payment_fee\", \"$txn_id\", \"$txn_type\", \"$first_name\", \"$last_na me\", \"$address_street\", \"$address_city\", \"$address_state\", \"$address_zip \", \"$address_country\", \"$address_status\", \"$payer_email\", \"$payer_status \", \"$payment_type\", \"$notify_version\", \"$verify_sign\" ) ";
"psales" - top line
"$quanti ty" "$last_na me" and "$payment_gr oss" on the other hand, they may be intentional, I haven't read it thoroughly yet
|
