Jump to content


Photo

extract info from database


  • Please log in to reply
1 reply to this topic

#1 Deserteye

Deserteye
  • Members
  • PipPipPip
  • Advanced Member
  • 31 posts
  • LocationNew Jersey

Posted 26 October 2006 - 12:07 AM

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?

What I know:
XHTML: 10/10
CSS: 8/10
JavaScript: 5/10
VBScript: 7/10 PHP: 8/10 MySQL: 9/10

#2 marcus

marcus
  • Members
  • PipPipPip
  • Advanced Member
  • 1,842 posts
  • LocationRochester, NY

Posted 26 October 2006 - 12:11 AM

<?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];?>

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users