extract info from database

[Deserteye]

I am making a profile script where it displays a users info. what would be the best function to use to extract from the database?

How would I extract data from multiple tables?

[marcus]

[code]
<?php
$connection = mysql_connect(host,dbuser,dbpass);
$db = mysql_select_db(dbname,$connection);
$sql = "SELECT * FROM dbtable1 WHERE dbtable1.id=$_GET[id];";
$result = mysql_query($sql);
$sql2 = "SELECT * FROM dbtable2 WHERE dbtable2.id=$_GET[id];";
$result2 = mysql_query($sql2);
$result3 = mysql_fetch_assoc($result);
$result4 = mysql_fetch_assoc($result2);
?>
welcome to <?=$result3[username];?>'s profile.
email: <?=$result4[email];?>
[/code]

just use $result3[dbtable] to get info from the first table in your database just change dbtable with your database fields, and the same for $result4[dbtable], just change dbtable to your field in your dbtable1.