Any have any ideas how I could condense this code? Manybe make 1 list out of 5?
<?php require_once('../Connections/Remote_Database_Connection.php'); ?>
<?php
mysql_select_db($database_Remote_Database_Connection, $Remote_Database_Connection);
$query_Recordset1 = "SELECT * FROM concerts ORDER BY `date` ASC";
$Recordset1 = mysql_query($query_Recordset1, $Remote_Database_Connection) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
mysql_select_db($database_Remote_Database_Connection, $Remote_Database_Connection);
$query_Recordset2 = "SELECT * FROM venues ORDER BY description ASC";
$Recordset2 = mysql_query($query_Recordset2, $Remote_Database_Connection) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
mysql_select_db($database_Remote_Database_Connection, $Remote_Database_Connection);
$query_Recordset3 = "SELECT * FROM locations ORDER BY city ASC";
$Recordset3 = mysql_query($query_Recordset3, $Remote_Database_Connection) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysql_num_rows($Recordset3);
mysql_select_db($database_Remote_Database_Connection, $Remote_Database_Connection);
$query_Recordset4 = "SELECT * FROM locations ORDER BY `state` ASC";
$Recordset4 = mysql_query($query_Recordset4, $Remote_Database_Connection) or die(mysql_error());
$row_Recordset4 = mysql_fetch_assoc($Recordset4);
$totalRows_Recordset4 = mysql_num_rows($Recordset4);
?>
<font face="verdana" size="1">
<?
// CONNECT INFO
$dbhost="localhost";
$dbuser="localhost";
$dbpass="localhost";
$db="localhost";
$table="localhost";
// CONNECT TO DATABASE
mysql_connect ($dbhost,$dbuser,$dbpass);
@mysql_select_db ($db);
if ($delete)
{
$sql = "DELETE FROM $table WHERE ID = '$delete'";
$sql_result = mysql_query($sql) or die("Couldn't execute query.");
}
// INSERT LINK
if ($DATEBOX)
{
$sql = "INSERT INTO $table (DATE, ARTIST, SETLIST, VENUE, LOCATION, PROSTATE, MEDIA, DISCS) VALUES('$DATEBOX', '$ARTISTBOX', '$SETLISTBOX', '$VENUEBOX', '$LOCATIONBOX', '$PROSTATEBOX', '$MEDIABOX', '$DISCSBOX')";
$sql_result = mysql_query($sql) or die("Couldn't execute query.");
}
// Grab
$result = mysql_query("select ID,DATE,ARTIST,SETLIST,VENUE,LOCATION,PROSTATE,MEDIA,DISCS from $table");
// $result = mysql_query("SELECT * FROM $table order by DATE ASC LIMIT 0, 30");
$num_fields = mysql_num_fields($result);
$num_rows = mysql_num_rows($result);
$row_cnt = 0;
while ($num_rows>$row_cnt)
{
$record = @mysql_fetch_row($result);
echo "<br>$record[0] - $record[1] - $record[2] - $record[3] - $record[4] - $record[5] - $record[6] - $record[7] - $record[8] - "."<a href=\"$PHP_SELF?delete=$record[0]\">DELETE</a>\n";
$row_cnt++;
}
?>
<br>
<br>
<p>
<FORM method=post action="<? $PHP_SELF ?>">
<p align="left"><b> Add to links: </b><BR>
Date:
<select name="DATEBOX" id="DATEBOX">
<?php
do {
?>
<option value="<?php echo $row_Recordset1['date']?>"><?php echo $row_Recordset1['date']?></option>
<?php
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
$rows = mysql_num_rows($Recordset1);
if($rows > 0) {
mysql_data_seek($Recordset1, 0);
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
}
?>
</select>
<BR>
Artist:
<input name="ARTISTBOX" type="text" id="ARTISTBOX" value="The Tragically Hip" size="40">
<BR>
Setlist:
<select name="SETLISTBOX" id="SETLISTBOX">
<?php
do {
?>
<option value="<?php echo $row_Recordset1['id']?>"><?php echo $row_Recordset1['date']?></option>
<?php
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
$rows = mysql_num_rows($Recordset1);
if($rows > 0) {
mysql_data_seek($Recordset1, 0);
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
}
?>
</select>
<br>
Venue :
<select name="VENUEBOX">
<?php
do {
?>
<option value="<?php echo $row_Recordset2['description']?>"<?php if (!(strcmp($row_Recordset2['description'], ucfirst($row_Recordset2['description'])))) {echo "SELECTED";} ?>><?php echo $row_Recordset2['description']?></option>
<?php
} while ($row_Recordset2 = mysql_fetch_assoc($Recordset2));
$rows = mysql_num_rows($Recordset2);
if($rows > 0) {
mysql_data_seek($Recordset2, 0);
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
}
?>
</select>
<br>
Location :
<select name="LOCATIONBOX">
<?php
do {
?>
<option value="<?php echo $row_Recordset3['city']?>"><?php echo $row_Recordset3['city']?></option>
<?php
} while ($row_Recordset3 = mysql_fetch_assoc($Recordset3));
$rows = mysql_num_rows($Recordset3);
if($rows > 0) {
mysql_data_seek($Recordset3, 0);
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
}
?>
</select>
<br>
Pro/State:
<select name="PROSTATEBOX">
<?php
do {
?>
<option value="<?php echo $row_Recordset4['state']?>"><?php echo $row_Recordset4['state']?></option>
<?php
} while ($row_Recordset4 = mysql_fetch_assoc($Recordset4));
$rows = mysql_num_rows($Recordset4);
if($rows > 0) {
mysql_data_seek($Recordset4, 0);
$row_Recordset4 = mysql_fetch_assoc($Recordset4);
}
?>
</select>
<br>
Media :
<SELECT name="MEDIABOX" size=1>
<OPTION selected>
<OPTION>Audio
<OPTION>SHN
<OPTION>DVD
<OPTION>MP3
<OPTION>MPG
<OPTION>AVI
<OPTION>MOV
</SELECT>
<br>
Discs :
<SELECT name="DISCSBOX" size=1>
<OPTION selected>
<OPTION>1
<OPTION>2
<OPTION>3
</SELECT>
<br>
<input type=submit name="submit" value="submit" >
</FORM>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
mysql_free_result($Recordset3);
mysql_free_result($Recordset4);
?>
