|
radio
|
7){
$weekday = date('w');
} else {
$weekday = $nday;
}
//echo $weekday;exit;
$table = 'palinsesto';
showTables($table,$weekday);
function connectToDB(){
@ $db = mysql_pconnect('80.241.167.242', 'root', 'ebd1d89e');
if(!$db)
{ echo 'Error: non puo connettersi al database'; exit; }
mysql_select_db('radiolavoce');
}
function showTables($table,$weekday)
{
connectToDB();
$weekArray = array('dom','lun','mar','mer','gio','ven','sab');
$weekdaysArray = array('domenica','lunedi','martedi','mercoledi','giovedi','venerdi','sabato');
$query = "select * from ".$table." where weekday = '". $weekArray[$weekday]."' order by 'time'";
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);
$num_fields = mysql_num_fields($result);
echo "";
echo "";
mysql_free_result($result);
}
?>
|
