0 ORDER BY a.featured_status ASC LIMIT 10 "; $result = mysql_query($query); // Create array - start if (mysql_num_rows($result) > 0) { $latest_product_array = array(); while ($row = mysql_fetch_array($result)) { $latest_product_array[] = $row; } mysql_free_result($result); // Release from memory - row } // Create array - end $query = " SELECT a.id AS id, a.width AS width, a.height AS height, a.category_id AS category_id FROM banners AS a WHERE a.deleted = 0 AND a.status = 1 ORDER BY a.id ASC LIMIT 3 "; $result = mysql_query($query); // Create array - start if (mysql_num_rows($result) > 0) { $banner_array = array(); while ($row = mysql_fetch_array($result)) { $banner_array[] = $row; } mysql_free_result($result); // Release from memory - row } // Create array - end $query = " SELECT a.id AS id, a.width AS width, a.height AS height, a.category_id AS category_id FROM banners AS a WHERE a.deleted = 0 AND a.status = 1 ORDER BY a.id ASC LIMIT 3,2 "; $result = mysql_query($query); // Create array - start if (mysql_num_rows($result) > 0) { $banner_2_array = array(); while ($row = mysql_fetch_array($result)) { $banner_2_array[] = $row; } mysql_free_result($result); // Release from memory - row } // Create array - end $query = " SELECT a.id AS id, a.width AS width, a.height AS height, a.category_id AS category_id FROM banners AS a WHERE a.deleted = 0 AND a.status = 1 ORDER BY a.id ASC LIMIT 5,1 "; $result = mysql_query($query); // Create array - start if (mysql_num_rows($result) > 0) { $banner_3_array = array(); while ($row = mysql_fetch_array($result)) { $banner_3_array[] = $row; } mysql_free_result($result); // Release from memory - row } // Create array - end ?>