Jump to content

Archived

This topic is now archived and is closed to further replies.

Deserteye

extract info from database

Recommended Posts

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?

Share this post


Link to post
Share on other sites
[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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.