Go to Detail Page - Display data on the same Master Page

Heya Crystal,

First you must have a database table setup for master/detail with fields for auto-increment primary key id, title, article, etc. Create recordsets later on as instructed from this database table.

In page.php setup a recordset named master to show master links. Then add a repeat region for the hyperlinks with a url parameter added to the master hyperlinks on page.php as id = to recordset primary key id  so master link repeat region code would look something like this where you want links to appear on page:

<?php do { ?>

<a href="page.php?id=<?php echo $row_master['id']; ?>"><?php echo $row_master['title']; ?></a><br />

<?php } while ($row_master = mysql_fetch_assoc($master)); ?>

In page.php create another recordset named details filtered by url parameter for id and place binding for details recordset into page.php where you want to detail of the selected article to appear. Your details recordset binding code will look something like this:

<?php echo $row_details['title']; ?><br />

<?php echo $row_details['article']; ?>

Next create a conditional region in page.php so if url parameter id is sent then it will show results from the details recordset and if no id parameter is sent it will show list of master links.

Place repeat region into area of conditional region where you want master links to appear and place binding from details recordset into area of conditional region where you want the details to appear. Conditional region will look something like this:

<?php

// Show IF id not sent

if (@$_GET['id'] == "") {

?>

repeat region of master links

} else { ?>

binding from detail recordset

<?php }

// endif id is sent

?>

This will make page.php display all the hyperlinks which go to

page.php?id=1

page.php?id=2

page.php?id=3

etc.

If you visit page.php with ?id=xxx you will see xxx details on page.php

One file to show master links and the details of the selected link. Hope that helps!