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, 1533🔥, 0💬
Popular Posts:
What validation keywords I can use in JSON Schema to specifically validate JSON Array values? The cu...
How To Set session.gc_divisor Properly in PHP? As you know that session.gc_divisor is the frequency ...
What properties and functions are supported on requests.models.Response objects? "requests" module s...
How to send an FTP request with the urllib.request.urlopen() function? If an FTP server supports ano...
How To Read Data from Keyboard (Standard Input) in PHP? If you want to read data from the standard i...