query("SELECT * FROM `stalls` ORDER BY RAND() LIMIT 20"); } else { $result = $conn->query("SELECT * FROM `stalls` WHERE `stall_city` LIKE '%$location%' OR `stall_postcode` LIKE '%$location%' ORDER BY RAND() LIMIT 20"); } } else { $result = $conn->query("SELECT * FROM `stalls` WHERE ((`stall_category` LIKE '%$category%' OR `stall_services` LIKE '%$category%' OR `stall_name` LIKE '%$category%') AND (`stall_city` LIKE '%$location%' OR `stall_postcode` LIKE '%$location%')) ORDER BY RAND() LIMIT 20"); } $result_total_count = $result->num_rows; } else { $result = $conn->query("SELECT * FROM `stalls` ORDER BY RAND() LIMIT 20"); $result_total_count = $result->num_rows; } ?> Online Market Stalls
What are you looking for?

Search by Category

Showing results -

num_rows > 0) { while ($row = $result->fetch_assoc()) { $stall_id = $row['stall_id']; $conn->query("UPDATE `stalls` SET `view_count` = view_count + 1 WHERE `stall_id` = '$stall_id'"); $stall_name = $row['stall_name']; $stall_address_1 = $row['stall_address_1']; $stall_address_2 = $row['stall_address_2']; $stall_city = $row['stall_city']; $stall_postcode = $row['stall_postcode']; $stall_email = $row['stall_email']; $stall_number = $row['stall_number']; $stall_logo = $row['stall_logo']; $stall_img = $row['stall_img']; $stall_desc = $row['stall_desc']; $stall_category = $row['stall_category']; $stall_services = $row['stall_services']; $dir = 'stall_images/'.$stall_id.'/'; $imgs = scandir($dir); $cover_img = ''; foreach($imgs as $img){ if($img == '.' || $img == '..'){ } else { $full_img = $dir.$img; $thb_img = $dir.'thb_'.$img; $cover_img = $thb_img; } } if($cover_img == ''){ $cover_img = 'stall_images/default.png'; } ?>