Pass a variable generated by hyperlink?

[34534534534555]

Hello,

I have generated the following code, which displays a list of records from a mysql database, and makes the auctionid field the hyperlink.

<?php 
include(&quot;dbconnect.php&quot;);

$sql = &quot;SELECT auction.auctionid, auction.bookcondition, book.edition, bid.bidprice
		FROM auction, book
		LEFT JOIN bid ON auction.auctionid=bid.auctionid
		WHERE sellerusername <> '$username'
		AND auction.isbn = book.isbn&quot;;
		
$query = mysql_query($sql) or die(&quot;Cannot query the database: &quot; . mysql_error());
	
echo &quot;<table width=500 border=1 cellspacing=0 cellpadding=0>&quot;;
echo &quot;<tr><td width=75 align=left>Auction</td><td width=100 align=left>Book Condition</td><td width=100 align=left>Book Edition</td>
<td width=100 align=left>Current Price</td></tr>&quot;;
	
	while ($myrow = mysql_fetch_array($query)) 
	{	
		$auctionid = $myrow[&quot;auctionid&quot;];
		$bookcondition = $myrow[&quot;bookcondition&quot;];
		$bookedition = $myrow[&quot;edition&quot;];
		$bidprice = $myrow[&quot;bidprice&quot;];
		
	echo 
		&quot;<tr>
			<td width=100 align=left><a href=bid.php>$auctionid</a></td>
			<td width=100 align=left>$bookcondition</td>
			<td width=100 align=left>$bookedition</td>
			<td width=100 align=left>$bidprice</td>
		</tr>&quot;;  
	}


mysql_free_result($booktitles);
?>

The problem i am trying to solve, and hope you will be able to, is how to pass the auctionid to the bid page which all the hyperlinks point to?

Thanks in Advance


| Feedback is always appreciated as this will help to further our knowledge as well |

 

[hos2]

<a href=bid.php?auctionid=$auctionid>$auctionid</a></td>

something like this ?

 

[34534534534555]

many thanks, that works just as required.

simple one eh!