teammatt3 — Sat, 01 Apr 2006 23:08:52 +0000

I figured it out. This is the code I used

<?php
$db = mysql_connect(\"localhost\", \"root\");

mysql_select_db(\"itaa_accounts\",$db);

$result = mysql_query(\"SELECT * FROM accounts\",$db);

echo \"<table border=1>\n\";
echo \"<tr><td>First Name</td><td>Last Name</td><td>Address</td><td>City</td><td>State</td><td>Zip</td><td>Email</td></tr>\n\";
while ($myrow = mysql_fetch_row($result)) {
        printf(\"<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n\",
        $myrow[0], $myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5], $myrow[6], $myrow[7]);


}

echo \"</table>\n\";
?>

teammatt3 — Sat, 01 Apr 2006 22:51:04 +0000

I just want to pull the whole table either student, or manager.

Busy — Sat, 01 Apr 2006 22:49:50 +0000

You mean pull the contents from both tables and display all (or parts) of the results?

kinda like:
SELECT * FROM students a, managers b WHERE b.sudent_name='$name' AND b.managers_id=a.student_id;