when i change a link on a form sql query wont work

[dmcb]

The problem i am having is that when i change a link in a form a sql query wont work.

the query works when i use this link(index3.php) in the form, this is a link  from my website.

Code: [Select]

<center><p>
<form action="index3.php" method="post">
                         <input type="hidden" name="cmd" value="_cart">
<input type="hidden" name="upload" value="1">
<input type="hidden" name="business" value="derek.skybc3@gmail.com">
<?php paypal_items(); ?>
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="amount" value="<?php echo $total; ?>">
<input type="image" src="http://www.paypal.com/en_US/i/btn/x-click- but03.gif" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
</form>
</p></center>


But the query does not work when i use this link(https://www.paypal.com/cgi-bin/webscr) in the form. this is a link to the paypal website

Code: [Select]

<center><p>
<form action="index3.php" method="post">
        <input type="hidden" name="cmd" value="_cart">
<input type="hidden" name="upload" value="1">
<input type="hidden" name="business" value="derek.skybc3@gmail.com">
<?php paypal_items(); ?>
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="amount" value="<?php echo $total; ?>">
<input type="image" src="http://www.paypal.com/en_US/i/btn/x-click-but03.gif" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
</form>
</p></center>


is this because the paypal link is an external link
Can anyone help please and does anyone know how i could get the query working with the paypal link in the form ??

[dmcb]

Sorry the second piece of code should be this

Code: [Select]

<center><p> <form action="https://www.paypal.com/cgi-bin/webscr" method="post">        <input type="hidden" name="cmd" value="_cart"> <input type="hidden" name="upload" value="1"> <input type="hidden" name="business" value="derek.skybc3@gmail.com"> <?php paypal_items(); ?> <input type="hidden" name="currency_code" value="EUR"> <input type="hidden" name="amount" value="<?php echo $total; ?>"> <input type="image" src="http://www.paypal.com/en_US/i/btn/x-click-but03.gif" name="submit" alt="Make payments with PayPal - it's fast, free and secure!"> </form> </p></center>



[Ojoshiro]

What SQL query doesn't work?
By changing the link you submit the form to paypal.com. What happens there with the information is outside your reach. ( unless you found a way onto their webservers in which case I will now disable my account there  ). This means that it doesn't get sent to a script on your server anymore and therefor no script you write will run a query on your database.

I must admit I have no idea how you can get it to work with the link. If this is a standard interface paypal offers then I'm sure they have documentation on it.

Good luck.
O.

[dmcb]

i got it working, submitted the form to a page on my website first, which auto submitted the paypal link