How to make the links work

pleisar

I need help im like ultra new in this thing

and so far ive managed to make data from my database in msyql appear in a php page via a recordset in dreamweaver mx and listing the contents of my table through dynamic text also in dreamweaver mx

i have a table named authors yeah... and in this page called list.php im only showing the name of the authors from the table all listed as many records exists in the table.

i have another page that shows all the data from the table authors as many records exists in the table named details.php

how can i make that the list of authors that i have showing from the same table called authors in list.php shows only that author data in details.php and only that data using the author_id field or any other thing so i can refer to it specifically

i would really appreciate your mindstorm in this people

cgraz

you have your basic SELECT query. When you ouput their name, you make their name a link and pass a variable in the url with their id (in the database). Then on the details page, you grab the id out of the url and use it in your query to select ONLY that specific author. For example:


$query = mysql_query("SELECT * FROM your_table");

while ($row = mysql_fetch_array($query)) {
   echo "<a href='details.php?id=" . $row["id"] . "'>" . $row["author_name"] . "</a><br>";
}

Then on details.php, your url would look something like this:

yourdomain.com/details.php?id=7 (the id= part would be different depending on which author they chose. This is just what a possible outcome might look like). Now what you need to do is grab that ID from the url, and use it to build your next query, which selects only that author

$query = mysql_query("SELECT * FROM your_table WHERE id='" . $_GET['id'] . "'");

// display results

Cgraz