Carrying variable over to new page

[scavok]

I have a page that lists other pages by pulling them out of a database. The best example I can give to what I need is a forum.

/forums/viewforum.php?f=1

This is pretty much exactly what I need. I know how to populate the page that lists the other pages (that would be the equivalent to the forum index), but I don't know how to tell the pages it lists which stuff to take from the database. When they click on the link, it somehow passes the forum id to viewforum.php, so viewforum.php can take populate with the correct data.

How does this work?

Thanks

[TheDefender]

on viewforum.php, setup your SQL something like so:

$sql = "SELECT * FROM yourtable WHERE forumid='".$_GET['f']."'";
$getsql = mysql_query($sql) or mysql_die();

$gotsql = mysql_fetch_row($getsql);
echo $gotsql['field1'];
echo $gotsql['field2'];
//etc....

Once you get these basics, you can work on pulling multiple rows through mysql_fetch_array() or whatever... The php manual and mysql manual have great info on this kind of stuff.