PHP MSSQL - Query Multiple Tables Jointly

Q

PHP MSSQL - How To Query Multiple Tables Jointly?

✍: Guest

A

If you want to query information stored in multiple tables, you can use the SELECT statement with a WHERE condition to make an inner join. Assuming that you have 3 tables in a forum system: "users" for user profile, "forums" for forums information, and "posts" for postings, you can query all postings from a single user with a script as shown below:

<?php
  $con = mssql_connect('FYI_SQL_SERVER','sa','FYIcenter');

  $userID = 101;
  $sql = "SELECT posts.subject, posts.time, users.name,"
    . " forums.title"
    . " FROM posts, users, forums"
    . " WHERE posts.userID = ".$userID
    . " AND posts.userID = users.id"
    . " AND posts.forumID = forums.id";
  $res = mssql_query($sql, $con);
  while ($row = mssql_fetch_array($res)) {
    print($row['subject'].", ".$row['time'].", "
      .$row['name'].", ".$row['title']."\n");
  }  
  mssql_free_result($res);

  mssql_close($con);
?>

 

PHP MSSQL - Creating an Identity Column

PHP MSSQL - Searching Records by Keywords

SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows

⇑⇑ SQL Server Connection Tutorials

2024-02-09, 1239🔥, 0💬