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));
Rent Charter Buses Company
READ ALSO
Copy column from one array to other column in PHP

Copy column from one array to other column in PHP

I want the column mainSupplierIds from the array class_3_main to be linked to supplierIds for class_3_suppliers array

202
How to get throughput and response time in Jmeter in Non GUI mode

How to get throughput and response time in Jmeter in Non GUI mode

Actually I don't want to generate HTML file, it is unable to parse for rsp and tspI am using Jmeter on server and using from non GUI mode

40
TinyMCE - get first node

TinyMCE - get first node

In TinyMCE, I added a widget, that outputs quotesThe output contains as main tag and inside it's tag with inserted data

60
scroll bar position from the bottom to top with css

scroll bar position from the bottom to top with css

Is there any way for scroll bar (scrollbar-thumb) to change the position that it starts from the bottomSuggested to do it with CSS

39