@include_once( "/home/rockmusi/public_html/slimstat/inc.stats.php" ); function PrintMerchCoupon(){ ?>
} function PrintTopAd(){ print ' '; print ""; } function PrintSideAd(){ print ' '; } function ConnectToDB() { $dbh=mysql_connect ("localhost", "rockmusi_mtype", "7Y#3;d1^13Lj") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("rockmusi_mt"); } function PrintMerch($artista='',$artistb='',$artistc='') { if($artista != ''){ $sql = "SELECT * FROM `allposters` WHERE MATCH ( Title ) AGAINST ( '$artista' ) ORDER BY `rank` LIMIT 2"; $result = mysql_query($sql); if($result != '') { ?>|
if(strtolower($myrow["ProductType"]) != "t-shirt"){
print $myrow["ProductWidth"] . "x" . $myrow["ProductHeight"]; } ?>
|
} // end loop
if ($result != '') { print "
|
if(strtolower($myrow["ProductType"]) != "t-shirt"){
print $myrow["ProductWidth"] . "x" . $myrow["ProductHeight"]; } ?>
|
} // end loop
if ($result != '') { print "
|
if(strtolower($myrow["ProductType"]) != "t-shirt"){
print $myrow["ProductWidth"] . "x" . $myrow["ProductHeight"]; } ?>
|
} // end loop
if ($result != '') { print "
| email name city state |
| $b = 0; ?> $b = $b + 1; ?> $b = $b + 1; ?> $b = $b + 1; ?> $b = $b + 1; ?> $b = $b + 1; ?> | ||||||
| PrintTopAd(); ConnectToDB(); ?> |
if ($_GET['view'] == "video") {
if ($_GET['date']) { $thedate = $_GET['date']; }
else { $thedate = date("Ymd"); }
?>
VIDEO ARCHIVES
$today = date("Ymd"); if ($_GET['skip']) { $skip = $_GET['skip']; } else { $skip =0; } $sql = "SELECT * FROM `video` WHERE `date` <= $today ORDER BY `date` DESC LIMIT $skip , 20"; $result = mysql_query($sql); $sql = "SELECT * FROM `video` ORDER BY RAND LIMIT 1"; $random = mysql_query($sql); while($vidrow = mysql_fetch_array($result)) { ?> - - } // end while /* if(count($result) > ($skip+20)){ ?> */ } else { ?> IN THE KNOW
include("blog/recent.php"); ?>
} ?> |
|||||
![]() |
||||||
|
if (($_GET['view'] == "video") && ($_GET['date'])){
$thedate = $_GET['date'];
$dateword = "Archived ";
} else if ($_GET['view'] == "video") {
$thedate = date("Ymd")-1;
$dateword = "Yesterday's";
} else {
$thedate = date("Ymd");
$dateword = "";
}
// $sql = "SELECT * FROM `video` WHERE `date` = '" . $thedate . "' LIMIT 1";
// $result = mysql_query($sql);
//$sql = "SELECT * FROM `video` WHERE `date` <= '" . $thedate . "' AND `code` != '' ORDER BY `date` DESC LIMIT 1";
$sql = "SELECT * FROM `video` WHERE `code` != '' ORDER BY RAND() LIMIT 1";
$result = mysql_query($sql);
while($darow = mysql_fetch_array($result)) { ?>
print $dateword; ?>Video of the Day: -
print html_entity_decode($darow['code']); ?>
} // end while
?>
|
||||||
| STEAL THESE SONGS! | ||||||
|
$sql = "SELECT * FROM `mt_entry` WHERE `entry_status` = '2' AND (`entry_blog_id` = '3' OR `entry_blog_id` = '7' OR `entry_blog_id` = '9') ORDER BY `entry_created_on` DESC LIMIT 10";
$result = mysql_query($sql);
while($fe = mysql_fetch_array($result)) {
?>
if ($fe['entry_blog_id'] == '3') {
print "LIVE REVIEW: ";
$sqlb = "SELECT * FROM mt_live WHERE live_id = " . $fe['entry_id'] . "";
$im = mysql_fetch_array(mysql_query($sqlb));
$image = $im['live_520'];
}
if ($fe['entry_blog_id'] == '7') {
print "INTERVIEW: ";
$sqlb = "SELECT * FROM mt_interviews WHERE interviews_id = " . $fe['entry_id'] . "";
$im = mysql_fetch_array(mysql_query($sqlb));
$image = $im['interviews_photo'];
}
if ($fe['entry_blog_id'] == '9') {
print "FEATURE: ";
$sqlb = "SELECT * FROM mt_features WHERE features_id = " . $fe['entry_id'] . "";
$im = mysql_fetch_array(mysql_query($sqlb));
$image = $im['features_wideimage'];
}
?>
} ?>
if($image) { ?> } ?> print stripslashes($fe['entry_excerpt']);?> |
||||||
© Copyright 1998-2005 RockMusicReview.com. All Rights Reserved. |
||||||