Tools, FAQ, Tutorials:
Querying Multiple Tables Jointly in PHP
How To Query Multiple Tables Jointly in PHP?
✍: 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); ?>
⇒ Setting ID Column as Auto-Incremented in PHP
⇐ Performing Key Word Search in PHP
2016-10-17, 1532🔥, 0💬
Popular Posts:
Where Can I get a copy of the RSS XML Schema? RSS XML Schema is an XML Schema that defines how an RS...
How to add an API to an API product for internal testing on the Publisher Portal of an Azure API Man...
Where Is the Submitted Form Data Stored in PHP? When a user submit a form on your Web server, user e...
How to install .NET Framework in Visual Studio Community 2017? I have the Visual Studio Installer in...
How to add request URL Template Parameters to my Azure API operation to make it more user friendly? ...