Deserteye Posted October 26, 2006 Share Posted October 26, 2006 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? Quote Link to comment Share on other sites More sharing options...
marcus Posted October 26, 2006 Share Posted October 26, 2006 [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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.