Collections:
Query Multiple Tables Jointly in MySQL
How To Query Multiple Tables Jointly in MySQL?
✍: FYIcenter.com
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 include "mysql_connection.php"; $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"; $rs = mysql_query($sql, $con); while ($row = mysql_fetch_assoc($rs)) { print($row['subject'].", ".$row['time'].", " .$row['name'].", ".$row['title']."\n"); } mysql_free_result($rs); mysql_close($con); ?>
⇒ Define the ID Column as Auto-Incremented in MySQL
⇐ Build WHERE Criteria with Web Form Data in MySQL
2017-06-23, 2711🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...