Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Query Multiple Tables Jointly
How To Query Multiple Tables Jointly? - PHP Script Tips - Working with MySQL Database
✍: 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); ?>
2007-04-19, 4794👍, 0💬
Popular Posts:
What's the difference between J2SDK 1.5 and J2SDK 5.0? There is no difference, Sun Microsystems just...
What Is C Language? The C programming language is a standardized programming language developed in t...
How do we access attributes using “XmlReader”? Below snippets shows the way to access attributes. Fi...
How To Remove the Top White Space of Your Web Page? - CSS Tutorials - Introduction To CSS Basics The...
WHat will be the result of the following code? #define TRUE 0 // some code while (TRUE) { // some co...