\n\n"; $section = "News"; echo " \n"; echo " ".strtoupper($section)."\n"; echo " \n"; echo " \n"; echo " \n"; echo "

"; $showicon = 1; $result = mysql_query("SELECT * FROM mgo WHERE section LIKE '%$section%' AND datetime <= '".datetime()."' ORDER BY datetime DESC LIMIT 0,4"); while ($data = mysql_fetch_array($result)) { $id = $data['id']; include("inc/story.inc"); } $showicon = 0; $result = mysql_query("SELECT * FROM mgo WHERE section LIKE '%$section%' AND datetime <= '".datetime()."' ORDER BY datetime DESC LIMIT 5,0"); while ($data = mysql_fetch_array($result)) { $id = $data[id]; include("inc/story.inc"); } echo "

"; echo "More $section..."; echo "

\n"; echo " "; echo TopXArtists(10); echo "
"; echo JoinMailingList(); echo "
\n"; echo "\n\n"; echo "\n\n"; $section = "Reviews"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
".strtoupper($section)."

"; $showicon = 1; $result = mysql_query("SELECT * FROM mgo WHERE section LIKE '%$section%' AND datetime <= '".datetime()."' ORDER BY datetime DESC LIMIT 0,2"); while ($data = mysql_fetch_array($result)) { $id = $data['id']; include("inc/story.inc"); } $showicon = 0; $result = mysql_query("SELECT * FROM mgo WHERE section LIKE '%$section%' AND datetime <= '".datetime()."' ORDER BY datetime DESC LIMIT 2,3"); while ($data = mysql_fetch_array($result)) { $id = $data[id]; include("inc/story.inc"); } echo "

"; echo "More $section..."; echo "

"; echo "
NOW PLAYING
Here's what we're listening to at Music Goes On right now...

"; $nowplaying = mysql_fetch_array(mysql_query("SELECT * FROM nowplaying ORDER BY date DESC LIMIT 0,1")); $nowplaying[playing] = str_replace("|", "
", $nowplaying['playing']); echo format($nowplaying['playing']); echo "
"; /* echo "
"; echo "
SINGLE / WEEK
"; $oftheweek = mysql_fetch_array(mysql_query("SELECT * FROM oftheweek WHERE _of = 'single' AND date <= '".datetime(date)."' ORDER BY date DESC LIMIT 0,1")); $review = mysql_fetch_array(mysql_query("SELECT * FROM mgo WHERE id = '$oftheweek[review]'")); echo "
".icon($oftheweek[review])."
"; echo "$oftheweek[title]
$oftheweek[artist]
[REVIEW]
\n"; echo "
"; */ echo "
\n\n"; echo "\n\n"; $section = "Au_Vi"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
AUDIO/VIDEO

"; $showicon = 1; $result = mysql_query("SELECT * FROM mgo WHERE section LIKE '%$section%' AND datetime <= '".datetime()."' ORDER BY datetime DESC LIMIT 0,1"); while ($data = mysql_fetch_array($result)) { $id = $data[id]; include("/home/girishgu/public_html/mgo/inc/story.inc"); } $showicon = 0; $result = mysql_query("SELECT * FROM mgo WHERE section LIKE '%$section%' AND datetime <= '".datetime()."' ORDER BY datetime DESC LIMIT 1,1"); while ($data = mysql_fetch_array($result)) { $id = $data[id]; include("/home/girishgu/public_html/mgo/inc/story.inc"); } echo "

"; echo "More $section..."; echo "

\n\n"; ?>
Site Index