Values from multiple tables

djdaz

Is there a way to pull multiple values from different tables in a database in just one SQL query?

EG in a forum pick out the thread information, then the user information for the poster of that thread

If you get what i mean
Thanks

Kunax

you could try something like this

SELECT t1.threadsomething, t1.threadsomethingelse, t2.user, t2.info FROM threads t1, users t2 WHERE t1.userid = t2.id;

http://dev.mysql.com/doc/mysql/en/join.html

djdaz

Cheers ill give that a try

🙂

djdaz

Ive had a go at what you suggested and came up with this, quick test code.

<?php
include($_SERVER['DOCUMENT_ROOT'].'/includes/dbconnect.php');

$sql = mysql_query("SELECT p.time, u.username FROM users u, forum_posts p WHERE u.username=p.username");

mysql_result($sql,0);

echo $time;
?>

Im new to this stuff in MySQL so the above code is probably wrong. The problem is nothing is been echoed into the page.

I must admit i dont know how to acutally get the results correctly

Thanks

kpzani

try this

<?php
// dunno whats in this - lets hope it connects to the db server and then selects the appropriate database
include($_SERVER['DOCUMENT_ROOT'].'/includes/dbconnect.php');

// build sql query
$sql = mysql_query("SELECT forum_posts.time, users.username FROM users, forum_posts WHERE users.username=forum_posts.username");

// run the query
$res = @($sql);

// loop through each result
while ($record = @mysql_fetch_array($res)) {
echo $record["time"];
}
?>

Roger_Ramjet

Start with mysql statement syntax

Look at the select syntax

and for multiple table selection you need to know the join syntax