I am buggin out… Please help, I need to get this into flash!!!
<?php
// read in the connection settings
require("showlister_settings.inc.php");
require("showlister_methods.inc.php");
// connect to the RDBMS
$db = mysql_connect("$site","$user","$pass")
or die_now("<h2>Could not connect to database server</h2><p>Check passwords and sockets</p>");
// select the database
mysql_select_db("$database",$db)
or die_now("<h2>Could not select database $database</h2><p>Check database name</p>");
// select all the shows in the database
$result = mysql_query("select show_id, month, day, year, location, details, venue
from $database_table order by year, month, day",$db)
or die_now("<h2>Could not select shows</h2>");
// output the current shows
echo("<div class='box'>
<h3>Shows</h3>
</div>
<div class='box'>
");
echo("<table border='1' width='80%'>
");
echo(" <tr>
<td>date</td>
<td>venue</td>
<td>location</td>
<td>details</td>
</tr>
");
while($row = mysql_fetch_array($result)) {
$the_id = $row["show_id"];
$the_month = $row["month"];
$the_day = $row["day"];
$the_year = $row["year"];
$the_location = $row["location"];
$the_details = $row["details"];
$the_venue = $row["venue"];
// shows
echo(" <tr>
<td>$the_month" . "/" . "$the_day" . "/" . "$the_year" . "</td>
");
echo(" <td>" . "$the_venue" . "</td>
");
echo(" <td>" . "$the_location" . "</td>
");
echo(" <td>" . "$the_details" . "</td>
");
}
echo(" </tr></table>
</div>
");
?>