$sql = "SELECT COUNT(*) FROM (items JOIN user ON items.userId=user.ID) LEFT JOIN images ON items.itemId=images.idNum ";
if (isset($_GET['type'])) { $sql .= " WHERE type='". urlencode($_GET['type'])."'"; }
$sql .="GROUP BY itemId"
$result_count = mysql_query($sql) or die ("MySQL Error: ".mysql_error());
$numofrows = mysql_fetch_array ($result_count);
if(empty($page))
{ // Checks if the $page variable is empty (not set)
$page = 1; // If it is empty, we're on page 1
}
$limitvalue = ($page - 1) * $limit;
// Ex: (2 * 25) - 25 = 25 <- data starts at 25
$sql1 = "SELECT itemId, userId, description, date, city, county, idNum, name, price, type FROM (items JOIN user ON items.userId=user.ID) LEFT JOIN images ON items.itemId=images.idNum";
if (isset($_GET['type'])) { $sql1 .= " WHERE type='". urlencode($_GET['type'])."'"; }
$sql1 .="GROUP BY itemId"
$sql1 .= "limit $limitvalue, $limit";
$result = mysql_query($sql1) or die("Error: " . mysql_error());