want to print count value with other data but count doesn't work
194
January 24, 2018, at 9:26 PM
Here is my code. my problem is count doesn't work properly
$sql = "SELECT *, count(Id) as counts FROM `Bus_Ticket`
WHERE (start like '$start%' AND end like '$end%' AND date like '$date%' )
GROUP BY Bus_name" ;
$result = mysqli_query($con,$sql);
$response = array();
while($row = mysqli_fetch_array($result))
{
array_push($response,array("Name"=>$row[4],"BusNo"=>$row['counts']));
}
echo json_encode(array("server_response"=>$response));
-
05:30
-
04:00
-
00:00
-
10:30
-
9:10
-
07:40
Firebase Cloud Functions: PubSub, "res.on is not a function"
-
04:00
TypeError: Cannot read properties of undefined (reading 'createMessageComponentCollector')
-
9:20
-
7:40
POPULAR ONLINE
- typescript: tsc is not recognized as an internal or external command, operable program or batch file 111533 visits
- search for elements in a list 111064 visits
- In Chrome 55, prevent showing Download button for HTML 5 video 98826 visits
- RxJS5 - error - TypeError: You provided an invalid object where a stream was expected 96332 visits
- Ionic 2 - how to make ion-button with icon and text on two lines? 92527 visits
- NetBeans IDE - ClassNotFoundException: net.ucanaccess.jdbc.UcanaccessDriver 62041 visits
- Adding methods to es6 child class 22375 visits
