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, 1356🔥, 0💬
Popular Posts:
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...