Multiple MySQL Tables --> HTML Tables

[mouncef]

Hi all,

I have a newbie question, I hope somebody can help me out.

I have an HTML form (query.html) that has a drop down menu of all 50 states and 3 checkboxes of 3 years (1999, 2000 and 2001), I want users to be able to select one state and any year(s) they want (they can choose one or more years). I have a MySQL DB that has 3 tables, each table has data for one year (i.e. states99, states00 and states01).
I want to be able to have the results.php script connect to the database, make a query from multiple tables and display it to an HTML table, for example:
State | 1999 | 2000 or State | 1999 | 2001
AL |23,010|12,567|
.
.
.

Thank you for your time.

Mouncef

[Anon]

explain what you mean

[mouncef]

Basically, I want to be able to query data from multiple tables in a database and display it to one HTML table.

[Anon]

Note: The following is assuming in the HTML form, the name of the state drop down menu is state and the checkbox's names are yr1999, yr2000, yr2001; the three tables are also named yr999, yr2000, yr2001.

if ($yr1999) {
$sql = "SELECT * FROM yr1999 WHERE State='$state' LIMIT 1";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$infofor1999 = $myrow['State'];
}

and then repeat it for each year then take $infofor<year> and display it in a normal HTML table

if this isn't what you meant, please tell me in more detail what you mean