Selecting from multiple mySQL tables

[Anon]

Okay, here's the question in a nutshell:

I have a particular select I need to make for one of my scripts and I need to upgrade it a bit so as to select from more than just the main table; to select from 7 tables. Here's the code snippet as it is now:

mysql_query(
"select distinct r.fullname, m.sender from $message_table m, $rooms_table r
where m.timestamp > $time
and m.room = r.shortname
order by r.fullname, m.sender");

Any ideas as to how I can select from more than just one $message_table ? I want to be able to select from $message_table, $message_two , $message_three and so on.

Thanks in advance!

[Anon]

I dont really get what you mean 🙂, but try putting the tables in array, like
$tables=array("table1","table2",....."tablen");

and then you can make the query for this array....

is it what you mean?

Regards,

[Anon]

LWC wrote:

I have a particular select I need to make for one of my scripts and I need to upgrade it a bit so as to select from more than just the main table; to select from 7 tables. Here's the code snippet as it is now:

Hi,

check the MySQL manual for the "JOIN" command. JOIN allows to combine several tables into one select.

Thomas

[Anon]

Here's what I do:

$first = mysql_query("SELECT * FROM table_name1",$db);
$a = mysql_fetch_array($first);

$second = mysql_query("SELECT * FROM table_name2",$db);
$b = mysql_fetch_array($second);

Then you can use the $a[column_name] and $b[column_name] together...

Not sure if that's what you're looking for, but it's simple yet effective way to select from 2 or more different tables.