Retreiving variables from a sql query into a form
 

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

Re: Retreiving variables from a sql query into a form
 

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

Re: Retreiving variables from a sql query into a form
 

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

Huw

Re: Retreiving variables from a sql query into a form
 

You could run a query like:

[php]<?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);

?>[/php]