Collections:
PHP ODBC - Query Multiple Tables Jointly
PHP ODBC - 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 = odbc_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 = odbc_exec($con, $sql); while ($row = odbc_fetch_array($res)) { print($row['subject'].", ".$row['time'].", " .$row['name'].", ".$row['title']."\n"); } odbc_free_result($res); odbc_close($con); ?>
⇒ PHP ODBC - Creating an Identity Column
⇐ PHP ODBC - Searching Records by Keywords
⇑ SQL Server FAQs - PHP ODBC Functions - Managing Tables and Data Rows
2023-12-30, 1312🔥, 0💬
Popular Posts:
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...