A function to create an html page from a content extract from database

[vronsky]

I'm trying to understand how to build a catalog.
If I have a table named 'friends' in the database like

---

| name | content |

| john | is good |

I would like to print a page that display me the row 'name'
linked to a page that display his content.
Until now I manually created a page named "john_content.php"
But growing the database I think it is not the better way.
Could anybody suggest me a function to automatically build a link
from the 'name' and that can crate a page to display 'content'?
I'm trayng to study any build catalog or a tutorial,but I can't find the solution....
It must be very simple,but how to do it?
Thank you....

[Aeiri]

Pass variables over links, I.E.:

content.php?name=john
content.php?name=joe
content.php?name=bob

And have it use that name to read the database, I.E.:

if(isset($name){
$results=mysql_query("select * from whateveryourdatabaseis where name='$name'");

// parse results

}
else echo("Please enter a name.");

Hope this helps you...

NOTE: I just realized what I did....

Make sure register globals is on in your server or else use $_GET['name'] instead of $name.

[Aeiri]

Pass variables over links, I.E.:

content.php?name=john
content.php?name=joe
content.php?name=bob

And have it use that name to read the database, I.E.:

if(isset($name){
$results=mysql_query("select * from whateveryourdatabaseis where name='$name'");

// parse results

}
else echo("Please enter a name.");

Hope this helps you...

NOTE: I just realized what I did....

Make sure register globals is on in your server or else use $_GET['name'] instead of $name.