I need to add a paypal 'add to cart' button to my page to submit the contents of my table to a shopping cart. The contents of the table are variables as they are from a sql query. Does anyone know hoe I could get the paypal link(script below) to retreive the variables from my query and submit them to the shopping cart.

<form target="paypal" action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="image" src="https://www.paypal.com/en_GB/i/btn/x-click-but22.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
<input type="hidden" name="add" value="1">
<input type="hidden" name="cmd" value="_cart">
<input type="hidden" name="business" value="info@wildcar.co.uk">
<input type="hidden" name="item_name" value="">
<input type="hidden" name="item_number" value="">
<input type="hidden" name="amount" value="">
<input type="hidden" name="no_note" value="1">
<input type="hidden" name="currency_code" value="GBP">
</form>

I need $myrow[0] to be used for item_number, $myrow[1],$myrow[2],$myrow[3] and $myrow[4] to be combined to make item_name and $myrow[5] to be used for Ammount.

Thanks
Huw

Member Avatar for TKSS

can you provide more specifics on sql versions, platform, etc?

can you provide more specifics on sql versions, platform, etc?

The Host company use Linux servers and run the latest versions of SQL & PHP

Huw

You could run a query like:

<?php

// don't forget to create a connection to database first!

// i.e.:
@mysql_connect('localhost','username','password');

// and choose a database
@mysql_select_db('database_name');

// fetch the info from database
$myrow = @mysql_query("SELECT * FROM table");
// make it so that it's like $myrow[0], $myrow[1], etc.
$myrow = mysql_fetch_row($myrow);

?>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.