Display data from mysql database

[coasting]

Hi!

I am very new to PHP and am having a load of trouble with a page on my website - something I am sure most of you will find very easy!

Basically what I have is a mysql database with a list of roller coasters with their stats and what I want to do is:

Display a list of the coasters on one page with every other line colored gray to make it easier to read - that bit I can do.

The next bit I want is the names of the coasters to become links and then depending on what link you choose the relevant details of that coaster are shown on a new page - I have seen examples of stuff like this where you get the URL like www.mysite.co.uk/list?id=1

I have done this in ASP but am having trouble with PHP - please help me! 😕

[bretticus]

Make sure your rollercoaster table has an auto-incrementing id field. At this point it's pretty simple

$sql = "SELECT coasterid, coaster FROM rollercoasters";
// ... query data...
// ... in while loop ...

echo "<a href=\"anotherpage.php?id={$row[0]}\">{$row[1]}</a>";

// ... On the other page ...

// safer external injection into query
$id = mysql_escape_string($_GET['id']);

$sql = "SELECT coaster, details [,more details...] FROM rollercoasters WHERE coasterid = '$id'";