hyperlink in a table

[Ducca]

Right here goes, i,m not gonna kid anyone but this is an assignment, its an on line auction site were you input to a database and read from a database and display the results in a table,
you have two tables
auction
bids
both have auction id as a variable
you input a item into auction using a form
you then have to input a bid for the relevant item and show all the bids for that item, using auction id, i enter the relevant number in the form field and using a query i compare the entered field $bid =1 with the auction id =1 in the bids table
this displays all the bids inputted for that auction id
sorted,
i,ve been at it for weeks made it work assignment done!!!
now suddenly tutor wants us to display bids by putting a link in the auction table so when you click it,it displays all the bids for that auction.
ps assignment spec says nothing about having a link in the tables just reading and writing to database and displaying bids per item, which i have done..
i,m not happy:mad:
can anyone help
thank you
ps sorry about the rant

[planetsim]

Depending on how you are storing bids etc this shouldnt be too hard a task.

If you are not storing them you will need to create a table something like this

id|auctionid|name|amount

From that to count the amount in each auction

$sql = "SELECT COUNT(auctionid) FROM bids WHERE auctionid = '".$auctionid."';

Than its basically to display them

$sql="SELECT id,auctionid,name,amount FROM  bids WHERE auctionid='".$_GET['auctionid']."' ORDER BY amount ASC";

I know you were honest but it is an assignmen t and if you have done most of this by yourself those queries should help complete the rest of the tasks with no problems.

[Ducca]

cheers thanks for that, ive already used the queries to store the bids in the bid tables then display them using

$query = "SELECT * FROM bids WHERE auctionid='$bid' ORDER BY bidprice";
$bid' being the auction id i have chosen then input into the form to show bids,
it all works fine its the hyperlink in a table thats just been thrown at us thats causing problems
i can create a hyperlink but how would the link differentiate between each auction id to display the relevant bids, auction id is the link between the two tables,
he wants us to click a link in the relevant row and show the bids for that item
as far as i,m concerned i,d put the work in and done the assignment now the goalposts have been moved
thanks again

[planetsim]

//query up above
while ($auction=mysql_fetch_array($query)) {
  echo '<a href="myfile.php?auctionid='.$auction['auctionid'].'>'.$auction['title'].'</a>';
}

Something like that should do it. Than its basically just getting the auctionid from the URL