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, 1290🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...