Deriving data from mySQL database

[npsari]

 

Hi there

 

I have a databse called phpb1

 

(The forums- obviously!)

 

I use the below simple code to retreive posts:

 

mysql_select_db(npsari_phpb1);

$q = "SELECT * FROM
phpbb_posts_text
ORDER BY ???? DESC
LIMIT 100;";
$res = @mysql_query($q);

 

But I want to arrange posts by Time

The Time is stored in another Table

 

How can I connect between two tables?

 

How can I say, sort by Date (which is in another table called post phpbb_posts)

 

 

[benjaminbeazy]

What you want is a join.

 

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

 

Something similar to the following, you'll have you plug in the actually table and field names...

 

mysql_select_db(npsari_phpb1);

 

$q = "SELECT phpbb_posts_text.id,phpbb_posts_text.text,phpbb_posts.postid, phpbb_posts.date AS date, FROM phpbb_posts_text JOIN phpbb_posts ON (phpbb_posts.postid = phpbb_posts_text.id) ORDER BY date DESC LIMIT 100;";

$res = @mysql_query($q);