include('dbconnect.php');
$category = $_REQUEST['category'];
if(!$category) { $photoquery = "SELECT * FROM photos WHERE mainpageorder != 0 ORDER BY mainpageorder"; }
if($category) {
$random = 1;
if($random == 1) { $photoquery = "SELECT * FROM photos WHERE category LIKE '%$category%' ORDER BY rand()"; }
else { $photoquery = "SELECT * FROM photos WHERE category LIKE '%$category%' AND categoryorder != 0 ORDER BY categoryorder"; }
}
$getphotos = $photos_db->query($photoquery) or die(mysqli_error($photos_db));
while($row = $getphotos->fetch_assoc()) {
foreach($row AS $var=>$val) { ${$var} = $val; }
$photoarray[$photoid] = "$photoname~$photosize";
$imagecount++;
if($photoid == '') { $photoid = uniqid(rand()); $photos_db->query("UPDATE photos SET photoid = '$photoid' WHERE rowid = '$rowid'") or die(mysqli_error($photos_db)); }
?>
} ?>
//$getphotos = $photos_db->query($photoquery) or die(mysqli_error($photos_db));
foreach($photoarray AS $photoid=>$photo) {
$photo = explode('~', $photo);
$photoname = $photo[0];
$photosize = $photo[1];
?>
} ?>