'" . $episodenumber . "' order by EPISODENO ASC limit 1") or die(mysql_error());
//$resultprevious = mysql_query("SELECT * FROM episodes WHERE EPISODENO<'" . $episodenumber . "' order by EPISODENO DESC limit 1") or die(mysql_error());
$resultrand = mysql_query("SELECT * FROM episodes WHERE USEINSIDEBAR = '1' AND DESSERT <> '1' AND RAND()<(SELECT ((18/COUNT(*))*10) FROM episodes) ORDER BY RAND() LIMIT 18;") or die(mysql_error());
$resultranddessert = mysql_query("SELECT * FROM episodes WHERE USEINSIDEBAR = '1' AND DESSERT = '1' AND RAND()<(SELECT ((15/COUNT(*))*10) FROM episodes) ORDER BY RAND() LIMIT 15;") or die(mysql_error());
$resultrandlatest = mysql_query("SELECT * FROM episodes ORDER BY EPISODENO DESC LIMIT 1") or die(mysql_error());
$resulttools = mysql_query("SELECT * FROM toolsused WHERE EPISODENO='" . $episodenumber . "'") or die(mysql_error());
while($rowlatestep = mysql_fetch_array( $resultrandlatest )) {
$latestepisode = $rowlatestep['EPISODENO'];
$latestepisodetitle = $rowlatestep['TITLE'];
$latestepisodevideoid = $rowlatestep['VIDEOID'];
$latestalternatepagename = $rowlatestep['ALTERNATEPAGENAME'];
$latestepisodeviews = $rowlatestep['VIEWS'];
}
//next and previous episodes for next/last buttons
//$numnext=mysql_numrows($resultnext);
//$numprevious=mysql_numrows($resultprevious);
//if($numnext > 0){
//while($rownext = mysql_fetch_array( $resultnext )) {
//$nextepisode = $rownext['EPISODENO'];
//}
//}else{
//$nextepisode = $episodenumber;
//}
//if($numprevious > 0){
//while($rowprevious = mysql_fetch_array( $resultprevious )) {
//$previousepisode = $rowprevious['EPISODENO'];
//}
//}else{
//$previousepisode = $episodenumber;
//}
//echo $views;
mysql_close($connection);
?>
Christmas Special with Laura Vitale - Laura in the Kitchen - Internet Cooking Show Starring Laura Vitale
