db_query($qry_string); while( $rowCh = $GLOBALS["m_DBConnect"]->db_fetch_array($resultCh) ) { genChannelInfo($rowCh); } $qry_string = "SELECT channel.name, channel.channel, shows.name, shows.original_name, shows.show_date, shows.start_time, shows.description, shows.type FROM shows, channel"; $qry_string .= " WHERE shows.channel = channel.channel"; $qry_string .= " and channel.region = 'IS' "; if ( $c ) { $qry_string .= " AND shows.channel = '$c' "; } $qry_string .= " AND shows.show_date = '"; $qry_string .= "$d'"; //$qry_string .= " AND (shows.start_time >= '20:00:00' AND shows.start_time <= '23:30:00') "; $qry_string .= " ORDER BY shows.channel, shows.show_date, shows.seq_number"; //echo $qry_string; $result = $GLOBALS["m_DBConnect"]->db_query($qry_string); if (!$result ) { genError("Engin gögn fundust !"); } else if ( $GLOBALS["m_DBConnect"]->db_num_rows($result) > 0 ) { while( $row = $GLOBALS["m_DBConnect"]->db_fetch_array($result) ) { genMain($row); } } else { genError("Engin gögn fundust !"); } genFooter(); ?>