PHP/MYSQL ordering 2 combined tables by time columns
Posted: Sat May 05, 2007 12:36 am
Jcart | Please use
This continues to echo all rows from each table, but does not put everything in descending order by time. If you know how this can be done, please help. Thanks 
Jcart | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
I'm using mysql5.0.32/php5.2.0-8, trying to get 2 tables echo'd out together and ordered by their time columns. column_id and column_id are the primary keys for each table. The data type is the same for each of the tables and looks like:
table1(column_id, time)
table2(column_id, time)
I've tried doing a UNION ALL between the sql statements, but have not been successful getting everything ordered by time.Code: Select all
<?php
include("config.php");
$sql = "(SELECT column_id, time FROM table1) UNION ALL (SELECT column_id, time FROM table2) ORDER BY time DESC";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query)) {
echo $row['column_id'] . ' ' . $row['time'] . '<br>';
}
?>Jcart | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]