Hi, will try and explain as easy as possible.

I have a php file the extracts data from a mysql table.

When it extracts it shows in a table.

The sql is select x x x from x x x where selections_id = 10

What I want to be able to do is insert a URL based on the selection and call it "Bet Now" in a column next to the "Win Price"

So, say you chose horse racing, Melbourne Cup. Melbourne cup is the sub category and has a subcategory_id = 10
When you chose that it then choses the maket and shows the odds.
What I want is in the end coloum to show "Bet Now" with a url link to //xxxxx.com/index.php?cPath=10&event_id=ALL&market_type_id=-#go_

What i need to know is how do I change the cPath=10 to the subcategory_id based on the selection.

To see it, go to http://www.plbet.com/horseracing.php

please post the code ....
how are you printing the table ?

please post the code to get complete help

I worked it out. thanks to those asking for the code. This is what I did

<?
$data_market = mysql_query($Query1,$dbh) or die(mysql_error());
$j=0;
while($ds1 = mysql_fetch_array($data_market))
{
$j++;
?>
<tr>
<td><?=$j?></td>
<td><?=$ds1[7]?></td>
<td><?=$ds1[8]?></td>
<td> <a href="<A href="https://www.xxxxx.com/index.php?cPath=<?=$ds1[5]?>&event_id=ALL&market_type_id=-#go_">Bet">https://www.xxxxx.com/index.php?cPath=<?=$ds1[5]?>&event_id=ALL&market_type_id=-#go_">Bet Now</a></td>
</tr>

For future reference, posting code is a lot easier to read etc. if you put it in [ code ] or [ php ] blocks.

Sorry - will do next time.