Thanks for the reply. $item_number is the ID number sent through from PayPal, as the purchased items tracking number.
The theory behind this plugin, is that they enter how much they want to top-up. They are then redirected to the appropriate PayPal URL, and an entry is added to the databasse for tracking purposes. When they get sent back after a successful putchase to ppc_paypal.cgi, that number is sent to the database, and it gets that purchase number, and updates the appropriate record to have their PayPal details, and setting SetID to to 1 (i.e it has been used).
I tried it with 1...but it still isn't working :-/ I know the query is working partially, as it updates ALL the other fields, except SetID
Any more ideas?
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
The theory behind this plugin, is that they enter how much they want to top-up. They are then redirected to the appropriate PayPal URL, and an entry is added to the databasse for tracking purposes. When they get sent back after a successful putchase to ppc_paypal.cgi, that number is sent to the database, and it gets that purchase number, and updates the appropriate record to have their PayPal details, and setting SetID to to 1 (i.e it has been used).
I tried it with 1...but it still isn't working :-/ I know the query is working partially, as it updates ALL the other fields, except SetID
Any more ideas?
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!