How do you create a link from data retrieved from the database
<p>I have products stored in a database. These items have ID, NAME, QUANTITY, and STOCK_NUMBER fields. I want to make an <code>href</code> for all of the data in the database:</p>

<pre><code>$Result=mysql_query("SELECT * FROM Products");
while($row=mysql_fetch_array($Result)){ 

href .....


}  
</code></pre>

<p>I want the result like this </p>

<p><code>item_id=1&amp;name_1_tv&amp;quantity_1=2&amp;stock_number_1=1411
&amp;item_id=2&amp;name_2_mobile&amp;quantity_2=5&amp;stock_number_2=5894
&amp;item_id=3&amp;name_3_radio&amp;quantity_3=2&amp;stock_number_3=18541
&amp;item_id=4&amp;name_4_tv&amp;quantity_4=2&amp;stock_number_4=1025
&amp;item_id=5&amp;name_5_computer&amp;quantity_5=1&amp;stock_number_5=1455
&amp;item_id=6&amp;name_6_cd&amp;quantity_6=2&amp;stock_number_6=5888</code></p>

<p>all these under the link</p>
