Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
impetrator
/
admin
/
counter
/
get-review-count
:
index.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php include_once "../../../admin/counter/db/config.php"; include '../../../admin/db/saucerer.php'; $listing_id = $_GET['listing_id']; $sql = "SELECT count(*) FROM reviews WHERE listing_id='$listing_id' AND deleted='' ORDER BY id DESC"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { if ($row['count(*)']==0) { echo 'No Reviews'; } elseif ($row['count(*)']==1) { echo ''.$row['count(*)'].' Review'; } else { echo ''.$row['count(*)'].' Reviews'; } } ?> </div>