I need my database info to show up!

[Pilot-Doofy]

Okay, I have the database and tables setup with all the information in them. I assign the variable "id" into the page but how do I get it to display the correct information for that specified id value?

I don't know what to put in in order for it to display it on the page.

My table is called "clans" and has the categories "name" "tag" "info" and "id" for the variable. Please help!

[weekender]

firstly, read the manual section on [man]mysql[/man]

second, do something like this

$link = mysql_connect($dbhost, $dbuser, $dbpass); // connect to db server
mysql_select_db($dbname); // select the database

$sql = "SELECT * FROM clans WHERE id = '$id'"; // query the db for that id

$result = mysql_query($sql); // execute the query

$row = mysql_fetch_assoc($result); // fetch the details

echo $row['id']; // echo the id of the fetched record

echo $row['name']; // echo the name of the fetched record