UR Play
Sortera programmen:
- ’;
echo’’;
echo ’’.$rad[’namn’].’’;
echo’
’;
//Database query ————————————————-
require(”connect.php”);
$today = DATE(”Y-m-d”);
$query = ”SELECT program.namn, program.url, program.bild, logo, klick, program.ingress, kanal.playnamn
FROM kanal, program, programklick
WHERE program.kdbnr = kanal.kdbnr
AND program.online LIKE ’1’
AND kanal.kdbnr LIKE ’80’
AND program.namn = programklick.namn
AND program.bild NOT LIKE ”
AND datum = ’”.$today.”’
ORDER BY klick DESC
LIMIT 0 , 99 ”;
$resultat = mysqli_query($dbc, $query);
$numrows = mysqli_num_rows($resultat);
//Populära program saknas ———————–
if ($numrows == 0) {
echo ’
echo ’
echo’
’;
include (”sections/closediv.html”);
}
$counter = 1;
echo ’
while ($rad = mysqli_fetch_array($resultat)) {
echo’
’;
}
echo ’
’;
?>
