I have a form, and a PHP script that acceses a MYSQL database. The results get outputed to an HTML active page. I now want to provide links to that information to generate a further SQL query and a further active page. e.g user searches through my form for all authors with the name of Hogg. They get six results from my database. I now want them to be able to click on the author they want for further info. But I'm stuck here and my 2 PHP books don't give any info. I've found out how to create a link attached to a URL, but don't know what to do from there. I don't need a tutorial here, just any links to info on the web which will tell me where to go, then I can sort it out myself.

Bob

Prob the best way to go about this is to format each link to contain an identifier of which author to display. Say your authors table has fields id, name, articles, other, then your search page would look at the name field, and for each one it would echo a link looking like http://www.yoursite.com/viewauthor.php?id=5 with the number on the end being the id number of that author.

Then you write one page, in this case called viewauthor.php that gets the id number from the URL that was clicked :

PHP Code:


$idnumber = $_GET['id'];

$result= mysql_query("lookup info for author number $idnumber...";

//display author info here 


The $_GET array contains the variable name-value pairs from after the ? in the URL.

Excellent. That's what I like simple solutions. Thanks for the help.

Bob