Code: Select all
<?php
//Display all entries
function display_all(){
$result = mysql_query("SELECT * FROM guide");
while($r=mysql_fetch_array($result))
{
$id=$r["id"];
$venue=$r["venue"];
$band=$r["band"];
$day=$r["day"];
echo "::<b>$venue</b><br> <b>$band</b><br><b>$day</b><br>";
}
}
//end display all function
//thursday
function Thurs(){
global $PHP_SELF;
$result = mysql_query("SELECT * FROM `guide` WHERE day = 'Thursday' ORDER BY `id`");
while($r=mysql_fetch_array($result))
{
$day=$r["day"];
$band=$r["band"];
echo "$day $band<br>";
}
echo "<br><a href='javascript:history.go(-1)'>[Go Back]</a><br><br>";
}
//end
//friday
function Fri(){
global $PHP_SELF;
$result = mysql_query("SELECT * FROM `guide` WHERE day = 'Friday' ORDER BY `id`");
while($r=mysql_fetch_array($result))
{
$day=$r["day"];
$band=$r["band"];
echo "$day $band<br>";
}
echo "<br><a href='javascript:history.go(-1)'>[Go Back]</a><br><br>";
}
//end
//saturday
function Sat(){
global $PHP_SELF;
$result = mysql_query("SELECT * FROM `guide` WHERE day = 'Saturday' ORDER BY `id`");
while($r=mysql_fetch_array($result))
{
$day=$r["day"];
$band=$r["band"];
echo "$day $band<br>";
}
echo "<br><a href='javascript:history.go(-1)'>[Go Back]</a><br><br>";
}
//end
//sunday
function Sun(){
global $PHP_SELF;
$result = mysql_query("SELECT * FROM `guide` WHERE day = 'Sunday' ORDER BY `id`");
while($r=mysql_fetch_array($result))
{
$day=$r["day"];
$band=$r["band"];
echo "$day $band<br>";
}
echo "<br><a href='javascript:history.go(-1)'>[Go Back]</a><br><br>";
}
//end
//monday
function Mon(){
global $PHP_SELF;
$result = mysql_query("SELECT * FROM `guide` WHERE day = 'Monday' ORDER BY `id`");
while($r=mysql_fetch_array($result))
{
$day=$r["day"];
$band=$r["band"];
echo "$day $band<br>";
}
echo "<br><a href='javascript:history.go(-1)'>[Go Back]</a><br><br>";
}
//end
//tuesday
function Tue(){
global $PHP_SELF;
$result = mysql_query("SELECT * FROM `guide` WHERE day = 'Tuesday' ORDER BY `id`");
while($r=mysql_fetch_array($result))
{
$day=$r["day"];
$band=$r["band"];
echo "$day $band<br>";
}
echo "<br><a href='javascript:history.go(-1)'>[Go Back]</a><br><br>";
}
//end
//wednesday
function Wed(){
global $PHP_SELF;
$result = mysql_query("SELECT * FROM `guide` WHERE day = 'Wednesday' ORDER BY `id`");
while($r=mysql_fetch_array($result))
{
$day=$r["day"];
$band=$r["band"];
echo "$day $band<br>";
}
echo "<br><a href='javascript:history.go(-1)'>[Go Back]</a><br><br>";
}
//end
?>
<Div align="center">
<form method="post">
<input type="hidden" action="<? echo $PHP_SELF; ?>" name="func" value="Thurs">
<input type="submit" value="Thurs">
<input type="hidden" action="<? echo $PHP_SELF; ?>" name="func" value="Fri">
<input type="submit" value="Fri">
<input type="hidden" action="<? echo $PHP_SELF; ?>" name="func" value="Sat">
<input type="submit" value="Sat">
<input type="hidden" action="<? echo $PHP_SELF; ?>" name="func" value="Sun">
<input type="submit" value="Sun">
<input type="hidden" action="<? echo $PHP_SELF; ?>" name="func" value="Mon">
<input type="submit" value="Mon">
<input type="hidden" action="<? echo $PHP_SELF; ?>" name="func" value="Tue">
<input type="submit" value="Tue">
<input type="hidden" action="<? echo $PHP_SELF; ?>" name="func" value="Wed">
<input type="submit" value="Wed">
</form>
</Div>
<?
switch($_SERVER['PHP_SELF'] = $func) {
default;
display_all();
break;
case "Thurs";
Thurs();
break;
case "Fri";
Fri();
break;
case "Sat";
Sat();
break;
case "Sun";
Sun();
break;
case "Mon";
Mon();
break;
case "Tue";
Tue();
break;
case "Wed";
Wed();
break;
}
?>the code above is a module in a small portal system ive had some of it working but it just defualts to the wed(); function. if you can understand what im trying to do please help me sort this crap out, yes im a newbie, is there an easier way?
what i basically want is a bunch of links like this:
thurs||fri||sat||sun|| etc etc ..
for the days of the week, and when one of the days are "click" it selects days from the database of whatever day was selected..all in one script!!
i no its a mess its my first real script.