Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Sql Sqljoin PHP SQL Inner Join

Related Tutorials


 
 

Share on Google+Share on Google+

PHP SQL Inner Join

Advertisement
JOIN is used to query data from two or more tables. The inner join is used in the case of need to return rows when there is at least one match in both tables.

PHP SQL Inner Join

     

This Example illustrates how to use the inner join clause in the sql query.

JOIN is used to query data from two or more tables. The inner join is used in the case of need to return rows when there is at least one match in both tables. This is the good example to understand inner join clause because in this example we use a join clause between only two table. We use "emp" table and "message" table and find the name from emp table and messages from the message table where emp_id in the emp table and emp_id in the  message table are equal. The fetched result is displayed on the browser as below. The complete source code is available below for download or copy the code as per your need.

 

 

 

 

Table: emp

Table: message

Source Code of innerJoin.php

<?php
  $con = mysql_connect("localhost","root","root");
  if (!$con) {
  die('Could not connect: ' . mysql_error());
  }

  mysql_select_db("test", $con);
  $result = mysql_query("SELECT emp.name, message.messages 
   FROM emp INNER JOIN message ON emp.emp_id = message.emp_id"
);
  echo "<table border='1'>
  <tr>
  <th>Name</th>
  <th>Message</th>
  </tr>";
  while ($row = mysql_fetch_array($result)) {
  echo "<tr>";
  echo "<td>" . $row['name'] "</td>";
  echo "<td>" . $row['messages'] "</td>";
  echo "</tr>";
  }
  echo "</table>";
  
  mysql_close($con);
?>

 

Output:

Download Source Code

Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: January 16, 2009

Related Tutorials

Discuss: PHP SQL Inner Join  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:2
Altaf Hussain
April 18, 2011
THANKS

WORKING WELL THANKS
deden web
July 13, 2013
thanks

verys work en simple...thanks very much...(^_^)
DMCA.com