Revision: 52173
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at October 15, 2011 02:06 by flatearthcomms
Initial Code
extract($_REQUEST);
$sql = "SELECT * FROM `site` WHERE `id`='1' ";
$result = doSQL($sql);
$r=mysql_fetch_array($result);
extract($r);
$sqlBG = " SELECT `bgFile` FROM `site_bgs` AS r1 JOIN
(SELECT (RAND() *
(SELECT MAX(bgID) FROM random)) AS id)
AS r2
WHERE r1.id >= r2.id
ORDER BY r1.id ASC
LIMIT 1; ";
$range_sql = " SELECT MAX(`bgID`) AS max_id , MIN(`bgID`) AS min_id FROM `site_bgs` " ;
$range_result = doSQL($range_sql);
$range_row = mysql_fetch_object( $range_result );
$random = mt_rand( $range_row->min_id , $range_row->max_id );
// Special code for Jane to test backgrounds
if ( isset($bg) ) {
$sqlBG = " SELECT * FROM `site_bgs` WHERE `bgID`='$bg' ";
} else {
$sqlBG = " SELECT * FROM `site_bgs` WHERE `bgID` >= $random LIMIT 0,1 ";
}
$resultBG = doSQL($sqlBG);
$rBG=mysql_fetch_array($resultBG);
$bg = $rBG['bgFile'];
Initial URL
Initial Description
Initial Title
Pick random field vale from mySQL (image filename etc)
Initial Tags
Initial Language
PHP