Here is my code:
-------------------------------
<?php
//variables
$current_date = (date("l F d, Y"));
$show = $show_name
?>
<table bgcolor=#AC1E1E align=center width="100%" cellpadding="0"
cellspacing="0">
<tr>
<td width="15%" bgcolor=#AC1E1E><div align="left"><img src="left.bmp"
width="19" border="0"></div></td><td align=center bgcolor=#AC1E1E><font
face=verdana size=1 color=#AC1E1E><b>Time</b></td>
<td colspan="2" width="40%" align=center bgcolor=#AC1E1E><font face=verdana
size=1 color=#AC1E1E><b>Channel</b></td>
<td width="45%" bgcolor=#AC1E1E><font face=verdana size=1
color=#AC1E1E><b>Summary</b></td><td align=right width="35%"><div
align="right"><img src="right.bmp" width="19" border="0"></div></td>
</tr>
<tr><td colspan=6 align=center>
<table width="100%" cellpadding="5" cellspacing="1">
<tr>
<td colspan=2 width="15%" align=center bgcolor=#AC1E1E><font face=verdana
size=1 color=#ffffff><b></b></td>
<td width="20%" align=center bgcolor=#AC1E1E><font face=verdana size=1
color=#ffffff><b></b></td>
<td colspan=2 align=center width="65%" bgcolor=#AC1E1E><font face=verdana
size=1 color=#ffffff>
<form><b>Select Date : </b><select name="current_date"
OnChange="this.form.submit();" style="border: 1px solid #000000; color:
black; font: 7pt verdana">
<?php
print("<option
value=\"display.php3?date=$current_date\">$current_date</option>\n");
?>
<?php
$query = "SELECT * FROM general_show ORDER BY 'date'";
$result = mysql_query($query, $mysql_access);
if(mysql_num_rows($result)) {
$id = 1;
while($row = mysql_fetch_row($result)) {
print("<option value=\"display.php3?date=$row[3]\">$row[3]</option>\n");
$id++;
}
}
?>
</select> <input type="button" value="Go!" onClick="this.form.submit();"
style="border: 1px solid #000000; color: black; font: 7pt verdana"></form>
</td>
</tr>
<?php
$query = "SELECT * FROM general_show WHERE date='$current_date' ORDER BY
'time'";
$result = mysql_query($query, $mysql_access);
if(mysql_num_rows($result)) {
$id = 1;
while($row = mysql_fetch_row($result)) {
print("<tr><td colspan=2 valign=\"middle\" width=\"15%\"
bgcolor=#E1DFDF>\n");
print("<font face=verdana size=1 color=black><div align=\"center\"><a
href=\"shows.php3?id=$row[0]\"><img src=\"$row[0].jpg\" border=\"1\"
width=\"80\" height=\"60\"></a></td><td width=\"20%\" valign=\"top\"
bgcolor=#ffffff>\n");
print("<font face=verdana size=1
color=black><b>$row[1]<br><br><br><br>$row[2]</b><br>$row[4]</td>\n");
print("<td width=\"45%\" valign=\"top\" bgcolor=#fffff><font face=verdana
size=1 color=black><b>$row[12]
(0$row[10]:0$row[11])</b><br>$row[13]</td>\n");
print("<td colspan=2 width=\"20%\" valign=\"top\" bgcolor=#E1DFDF><font
face=arial size=1 color=black><b>Starring :</b><br><br><i>Shannen
Doherty<br>Alyssa Milano<br>Holly Marie Combs</i></td></tr>\n");
print("</td></tr>\n");
$id++;
}
}
?>
</td></tr></table>
-----------------------------------------
I want the user to be able to use the select form and hence change the date
so that they can view a list of programmes from that date. Do you
understand?
So it has:
Friday 8th Feb, 2001
Saturday 9th.....
Sunday ....
Monday.....
When they select a date the contents of the table changes to show the
programmes for that date.
Sorry about this its just that it has REALLY been bugging me cause I can't
figure out what I am doing wrong......
The page needs to open though on the listings for the current date and I
want to limit the drop down box to only show listings for the next 14 days
from the day they access the page...
if you can help with any of this I would be over the moon!
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
