Discussion Board
\n";
$sqllink=mysql_connect("localhost", music, music);
mysql_select_db (scarlatti);
print "
| Subject |
Poster |
Date |
|
";
$result=mysql_query(" SELECT * FROM discussion where thread_ID='0' ORDER BY message_ID DESC");
while(list($message_ID,$thread_ID,$thread,$message,$poster,$poster_email,$notify,$display_date)=mysql_fetch_row($result))
{
print "| $thread |
$poster |
$display_date |
";
$replies=mysql_query(" SELECT * FROM discussion WHERE thread_ID='$message_ID' ORDER BY date DESC");
while(list($message_ID,$thread_ID,$thread,$message,$poster,$poster_email,$notify,$display_date)=mysql_fetch_row($replies))
{
print "
\n
|
\n
...Re: $thread\n
| \n
\n
$poster\n
| \n
$display_date | \n
\n";
}
}
print "
";
print "
[Start a new thread]";
include("footer.htm");
?>