Neatened the code a bit

1 files changed, 13 insertions, 12 deletions

@@ -4,16 +4,14 @@ include('db.php');
 
 ob_start();
 
-$posts = array();
-
 if (isset($_GET['id']))
 {
-        $getimages = "SELECT * FROM images WHERE id = " . $_GET['id'];
+        $getimage = "SELECT * FROM images WHERE id = " . $_GET['id'];
 } else {
-        $getimages = "SELECT * FROM images ORDER BY id DESC LIMIT 0,1";
+        $getimage = "SELECT * FROM images ORDER BY id DESC LIMIT 0,1";
 }
-$getimages2 = mysql_query($getimages);
-$getimage3 = mysql_fetch_array($getimages2);
+$getimage2 = mysql_query($getimage);
+$getimage3 = mysql_fetch_array($getimage2);
 
 ?>
                         <DIV CLASS="post">
@@ -39,8 +37,11 @@ $getimage3 = mysql_fetch_array($getimages2);
 <?php
 
 $id = $getimage3['id'];
-$all = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM images"));
-$all = $all['COUNT(*)'];
+
+$cntimages = "SELECT COUNT(*) FROM images";
+$cntimages2 = mysql_query($cntimages);
+$cntimages3 = mysql_fetch_array($cntimages2);
+$all = $cntimages3['COUNT(*)'];
 
 if ($id > 2)
 {
@@ -68,10 +69,10 @@ if ($id < $all)
         }
 }
 
-$getnpending = "SELECT COUNT(*) FROM pending";
-$getnpending2 = mysql_query($getnpending);
-$getnpending3 = mysql_fetch_array($getnpending2);
-$numpending = $getnpending3['COUNT(*)'];
+$cntpending = "SELECT COUNT(*) FROM pending";
+$cntpending2 = mysql_query($cntpending);
+$cntpending3 = mysql_fetch_array($cntpending2);
+$numpending = $cntpending3['COUNT(*)'];
 
 ?>
                         </UL>