Page 1 of 1

Table joins... Please help :P

Posted: Wed Mar 05, 2003 1:46 pm
by Jim
I need to create a command that does the following in one line:

$sql = select id, post_by, subject, post_body, template, UNIX_TIMESTAMP(post_date) AS postdate from ".$site."_news, ron_db order by id desc limit 20

and

$sql = select template from site_db where site_pre = '$site'

The SQL statements work fine separately... I just need a way to combine them into one. Any ideas?

Posted: Wed Mar 05, 2003 2:22 pm
by BDKR