Get dynamic link's name with onClick?

[Speedy]

Hi all,
I run a query in PHP on an existing database and convert resulting records (OrderNumbers) into hyperlinks. This spits out a number of results so the user can click any of the links. I would like to be able to click on the link and load the link's name into variable, so I can run another query using this variable later on. Or really just load the link's name into a hidden form field, whatever.

E.g. how can you? <a href="javascript:void(0)" onclick="Get the 'test' value and load it into variable or hidden form field?">test</a>
Below is the code generating links.

[PHP]
$rs=odbc_exec($conn,$sql);
if (!$rs)
{exit("Error in SQL");}
echo "<table><tr>";
echo "<th>Order Numbers Found:</th>";
"<th>Total Qty</th></tr>";
while (odbc_fetch_row($rs))
{
$orderno=odbc_result($rs,"OrderNo");
$qty=odbc_result($rs,"BuyQty");
echo "<tr><td>". "<a href=\"$orderno\">$orderno</a>" . "</td>";
echo "<td>$qty</td></tr>";}[/PHP]

Thanks
Speedy

[Speedy]

OK after reading quite a few articles about this issue I think I can answer myself and say it is most probably not possible to do it the way I want to.

INSTEAD:
Could you please help me with using the existing code and load the OrderNumbers into an option box on the form?

Thank you
Speedy

[ronverdonk]

Must be something like this, I presume?

[PHP] echo '<select name="myselect">';
while (odbc_fetch_row($rs)) {
$orderno=odbc_result($rs,"OrderNo");
$qty=odbc_result($rs,"BuyQty");
echo "<option value='$orderno'>$orderno</option>";
}
echo '</select>';
[/PHP]

Ronald :cool:

[Speedy]

Hi ronverdonk,
thanks for your reply. I figured how to load it into the option box already, but another user "iam_clint" helped me to use my preferred solution using the 'href's' attribute 'name'.
I then use this to run the detailed query and display details.

[PHP]echo "<a href=\"order_detail.php?name=$OrderNumber\">$Order Number</a>";[/PHP]

Speedy