Collections:
PHP MSSQL - Query Multiple Tables Jointly
PHP MSSQL - How To Query Multiple Tables Jointly?
✍: Guest
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
2024-02-09, 1270🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...