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, 1967🔥, 0💬
Popular Posts:
How To Remove Slashes on Submitted Input Values in PHP? By default, when input values are submitted ...
How to start Visual Studio Command Prompt? I have Visual Studio 2017 Community version with Visual C...
How to use the "set-variable" Policy Statement to create custom variables for an Azure API service o...
How to read RSS validation errors at w3.org? If your RSS feed has errors, the RSS validator at w3.or...
Where to find tutorials on HTML language? I want to know how to learn HTML. Here is a large collecti...