pulling data from different DB tables

[Anon]

I would like to create an Excel-like view (table) on a web page using data from different tables in a database. For example, I want the page to pull up a student's schedule when they login and their grade in that class. However, the data on these to fields are in different tables. Help!

Lindsay

[van__]

$sql = "SELECT * FROM table1,table2 WHERE fieldname.table1 = '$this_var' AND fieldname.table2 = fieldname.table1"

read up at your DB creators website for info on Join statements.

[majik-sheff]

How are the two tables structured?