If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

MySQL virtual html links

Hi all:

I am trying to find a tutorial to create virtual links and present them as an individual web page. To make it more clear, suppose I have an event list (i.e news) which I save in a SQL database and I would like to click on any of those events (i.e.headline) that would pull the data from the DB and show it in an individual page with details. I have been googling but dont exactly know the method. Please direct me too the correct source.

MySQL is just a database. You need a language like PHP to actually create an interface to get the data.

The typical method for doing this is to use variables in the URL called "GET" variables.

page.php?item=5

Then $_GET['item'] will have a value of 5 in PHP and you can use that to search for record 5 in the database. To generate that type of link just find the relevant info in the database and use PHP to generate the href of an <a href="...." that corresponds to what you want to do.