Extract Data from Database?

Hi,

I am facing a problem in fetching data from 2 tables simultaneously. I created 2 tables (user, data) where userid is used as primary key in user table while freign key in data table. I want to fetch address of user from table user on behalf of userid fetched from data table. Could someone help me to found a way to fetch data?

I am using below code:

while($row = mysql_fetch_array($result))
{
 if($row['image']=='')
 $row['image'] = 'default.jpg';
 echo "<tr>
 	<td><b>".ucfirst($row['prop_for'])." Property</b><br>".$row['prop_type'] ." for ".$row['purpose']."<br>
	<a href='prop.php?id=".$row['prop_id']."'><img src='product_images/".$row['image']."' width='150' height='100' border='0'></a></td>
	<td>".$row['prop_spec']."</td>
	<td>Rs. ".number_format($row['price']). "</td>
	<td>";
	$query1 = "SELECT * FROM user WHERE userid='".$row['userid']."'";
	$result1 = mysql_query($query1) or die('Error, query failed');
	while($add = mysql_fetch_array($result1))
	{
	 echo $add['email']."<br />".
	 $add['phone']."</td>
	</tr>
	<tr>
		<td colspan='4'><hr></td>
	</tr>";
	}
}

Code (markup):

 

what is the output you are getting up to this point?

 

try this code.

$query = 'SELECT u.*, d.* FROM user AS s JOIN data AS d ON s.userid = d.userid';
$result = mysql_query($query);

while($row = mysql_fetch_array($result))
{
       if($row['image']=='')
       $row['image'] = 'default.jpg';
       echo "<tr>
       	<td><b>".ucfirst($row['prop_for'])." Property</b><br>".$row['prop_type'] ." for ".$row['purpose']."<br>
      	<a href='prop.php?id=".$row['prop_id']."'><img src='product_images/".$row['image']."' width='150' height='100' border='0'></a></td>
      	<td>".$row['prop_spec']."</td>
      	<td>Rs. ".number_format($row['price']). "</td>
      	<td>".$row['email']."<br />".$row['phone']."</td>
      	</tr>
      	<tr>
      		<td colspan='4'><hr></td>
      	</tr>";
     
}

PHP: