joining query results

[rake]

Hrrm... how should i put this... Let me give you an example.

table_1 contains the fields: id, name, other
table_2 contains the fields: id,name,other2

$r1 = mysql_query("SELECT * FROM table_1");
while($rr1 = mysql_fetch_array($r1)) {

// print row in an html table

}

$r2 = mysql_query("SELECT * FROM table_2");
while($rr2 = mysql_fetch_array($r2)) {

// print row in an html table

}

my two tables are almost identical. Well, what i want to do is to display both table_1 and table_2 in the same html table and have the rows ordered by the "name" column. How could i do that? I've searched all i could and didn't find an answer.

Thanks in advance. 🙂

[sgoku01]

Something like this?

$select = mysql_query("SELECT a.* b.* FROM table_1 a, table_2 b ORDER BY a.name"); 
while($dips = mysql_fetch_array($select)) 
{ 
// print row in an html table 
} 

[[deleted]]

If you have mysql 4.0, you can use the UNION statement, check out the mysql manual.

If you are not using 4.0 you will have to run two queries and put the results into a temporary table, and then select from that temp table with an ORDER BY.

[rake]

Originally posted by vincente
If you have mysql 4.0, you can use the UNION statement, check out the mysql manual.


If you are not using 4.0 you will have to run two queries and put the results into a temporary table, and then select from that temp table with an ORDER BY.

Excellent! Thanks a lot! 🙂