setting up IPN (paypal)

[Moseeki ka Dast]

Hi

I am a bit of a novice at this, but I am trying to install some IPN script (from http://www.web-bureau.com/modules/free-php-paypal-ipn-script.php) onto my server to implement IPN.

My problem is that I am not sure how to create the following line in the database, so that the code can find the password from 'products' and 'pid':

if (strcmp ($payment_status, "Completed") == 0) {
$qry = "SELECT password FROM products WHERE pid = \"$item_number\" ";
$result = mysql_query($qry,$db);
while ($myrow = mysql_fetch_row($result)) { $passwd = $myrow[0]; }

I assume I have to create a table named products, which I have done, but where do I proceed from there? I am using phpMyAdmin which was already installed on my server.

Many thanks in advance!

Ben.

[JPnyc]

Well that table has to have at least those 2 fields then, password and pid. And don't change the case, keep it the same as the SQL statement

[jasonrose]

Do yourself a favour and get Libepal++
www.libesoft.com

Check their fascinating tool called DPN. The price is incredible for such
a good set of tools.

J

[so_is_this]

Hey, jasonrose, to sign up for the first time with a BB system and immediately cross-post the same advertisement three times is a violation of this site's use agreement.

http://www.webdeveloper.com/forum/showthread.php?t=110851
http://www.webdeveloper.com/forum/showthread.php?t=92583
http://www.webdeveloper.com/forum/showthread.php?t=128489