Here is my code:




$current_date = (date("l F d, Y"));
$show = $show_name


<table bgcolor=#AC1E1E align=center width="100%" cellpadding="0" 
<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><td colspan=6 align=center>
<table width="100%" cellpadding="5" cellspacing="1">

<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 
<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">





$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");


</select> <input type="button" value="Go!" onClick="this.form.submit();" 
style="border: 1px solid #000000; color: black; font: 7pt verdana"></form>


$query = "SELECT * FROM general_show WHERE date='$current_date' ORDER BY 
$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%\" 
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\" 
print("<font face=verdana size=1 
print("<td width=\"45%\" valign=\"top\" bgcolor=#fffff><font face=verdana 
size=1 color=black><b>$row[12] 
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");






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 

So it has:

Friday 8th Feb, 2001
Saturday 9th.....
Sunday ....

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

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to