Showing availability

Hi Guys,

I have a page that retrieves events from a database and displays them in a html table and makes

the name of the event a hyperlink.I have made the name of the event link to a page called ticketsavailable.php

Now i would like ticketsavilable.php to display available tickets for that

event.

I have a tickets table that has the columns

tickectID, price, and EventID.

so i guess my sql statement needs to say something like select all fields from Tickets table where eventID is equal to ticketID

Is this right ?

Why would the event be equal to the ticket? does the ticket id tell where the events are, tell us more. What is in these colums?

that was just a guess at the sql statement, from your response it sounds like i need to rework it.

I have an events table that has columns like eventid, eventname, eventdescription etc

I have another table called ticket that has tickectid, price, tickettype and eventid.

I would like to write the sql so that when people click on an event all the available tickets are displayed.

Maybe i need to have the ticketid in the event table ?

I think this is correct.
"select * where from ticket where eventid = $event" Then you would use a loop to display it all.