Advanced SQL

[Birdie]

Okay.

I need to find a SQL query which can output the fields i want out of 2 tables in order.

So basically its like...

SELECT f_name AS fname FROM db "and" select fname FROM leads "which are" ORDER BY fn ASC in both tables

Field names are different in both tables also....

Thanks.

[goughy000]

PHP Code:

$result = mysql_query("SELECT * FROM `table1`,`table2`");

while($row = mysql_fetch_array($result)){
    echo $row['table1.fieldname'];
    echo $row['table2.fieldname'];
} 


something like that?

[Birdie]

Why didnt i think of that, the ordering works perfect with it. I thought that would of done inside orderings but it doesnt.

Thanks.

Ah EDIT:

Er, does anyone know how to select these tables like above and use a SELECT f_name as fn for only 1 table so all data seems to be from 1 structure?

Thanks again.

EDIT 2:

Well.. i normally try and get away from UNION but heres the SQL i figured should work... but not all firstnames are ouputted and i dont have a clue why?

Code:

SELECT f_name as fn2 from db UNION select fn AS fn2 FROM leads

[goughy000]

erm, are the firstnames that arnt displayed all in a certain table?

[Birdie]

Doesn't matter... guess what it was...

UNION ALL....

Thanks anyway.

[Clay-C]

well if it was me, I just use simple query, something like SELECT * FROM tablename WHERE blah blah blah
then i just do it twice, one sorted with the firstname and then with the lastname (surname)... save them to variables $queryresult and $queryresult2...

then to sort on 2 tables I do the nobish things cause I'm a newb

print "<table><tr><td>firstname</td><td>lastname</td></tr>";

while ($arrayresult = mysql_fetch_array($queryresult))
{
print "<tr><td>$arrayresult[firstname]</td><td>$arrayresult[lastname]</td></tr>";
}
print "</table><table><tr><td>firstname</td><td>lastname</td></tr>";
while ($arrayresult = mysql_fetch_array($queryresult2))
{
print "<tr><td>$arrayresult[firstname]</td><td>$arrayresult[lastname]</td></tr>";
}
print "</table>";

it has 2 querys and 2 arrays but it gives the same result I think well don't laugh now cause I just started PHP and MySQL 2months ago so I'm a newb!

[Birdie]

The order wouldnt be right thought you see. It would order 1 set then start again on the 2nd set.