RE: [PHP] Getting Newest
| From: | John W. Holmes | Date: | Thu, 07 Nov 2002 02:42:12 +0000 |
| Subject: | RE: [PHP] Getting Newest | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-123095@lists.php.net to get a copy of this message | ||
> $sql = "select id, date, name, text from table1 union";
> $sql2 = "select id, date, name, text from table2 union";
> $sql3 = "select id, date, name, text from table3 order by date desc";>
No, it's all one query.
$sql = "select id, date, name, text from table1 union "
."select id, date, name, text from table2 union "
."select id, date, name, text from table3 order by date desc";
---John Holmes...