Sending a value to a page with a submit

[robinjohn]

Hi everyone,

I automatically create a table based upon a sql query, what I'd like to do next is to include a hyperlink that takes a value from the current row, sets the value of a global veriable, reload the page and take advantage of the new, user selected variable.

Here's the table code :

<?php while($db->next_record()): ?>
<tr>

My attempt.....
<td><a href = leads.php?ROWID= <?php print $db->Record["id"] ?> > <?php print $db->Record["id"] ?></a></td>

<td><?php print $db->Record["projectName"] ?></td>
<td><?php print $db->Record["workscope"] ?></td>
<td><?php print $db->Record["region"] ?></td>
<td><?php print $db->Record["contractManager"] ?></td>
</tr>
<?php endwhile ?>
</table>

[robinjohn]

Formatting'll be the death of me, it really will.
This (seems) to work

<?php echo "<td><a href = leads.php?ROWID=". $db->Record["id"] . ">" . $db->Record["id"] . "</a></td>";?>

So now I can use the ID the user selected to build another table beneath the first one, on the same page.