Reputation:
how can I get the result if this in php when my query is the following:
$query = "SELECT COUNT(*) AS call_count FROM `callsepaug` ";
$query .= "WHERE start_time BETWEEN '" . $start_date . "' AND ";
$query .= "'" . $end_date . "'";
Upvotes: 0
Views: 196
Reputation: 3397
It's the same as a simple query, you can get count(*)
with call_count
$queryBuild = "SELECT COUNT(*) AS call_count FROM `callsepaug` ";
$queryBuild .= "WHERE start_time BETWEEN '" . $start_date . "' AND ";
$queryBuild .= "'" . $end_date . "'");
$query = mysqli_query($queryBuild);
$result = mysqli_fetch_array($query);
echo $result['call_count'];
Or with object
$query = "SELECT COUNT(*) AS call_count FROM `callsepaug` ";
$query .= "WHERE start_time BETWEEN '" . $start_date . "' AND ";
$query .= "'" . $end_date . "'";
$result = mysqli_query($link, $query);
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
echo $row["call_count"];
Upvotes: 1
Reputation: 269
Try this:
$query = mysql_query("SELECT COUNT(*) AS call_count FROM `callsepaug` ";
$query .= "WHERE start_time BETWEEN '" . $start_date . "' AND ";
$query .= "'" . $end_date . "'");
$result = mysql_fetch_array($query);
echo $result[0];
Upvotes: 0
Reputation: 33935
Incidentally, you can write that code this way...
$query = "
SELECT COUNT(*) call_count
FROM callsepaug
WHERE start_time BETWEEN '$start_date' AND '$end_date';
";
Upvotes: 0
Reputation: 16086
Try like this:
<?php
$query = "SELECT COUNT(*) AS call_count FROM `callsepaug` ";
$query .= "WHERE start_time BETWEEN '" . $start_date . "' AND ";
$query .= "'" . $end_date . "'";
$result = $mysqli->query($query);
$row_array=$result->fetch_array(MYSQLI_ASSOC);
print($row_array['TOTALFOUND']);
Note: Mysql_* functions are deprecated. Avoid using these functions.
Upvotes: 0