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, 1305🔥, 0💬
Popular Posts:
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...