CODEWITHSUNDEEP
phpmysqlsql
user2203439
user2203439

Reputation:

How to get result from mysql when using Count(*) As

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

Answers (4)

Donovan Charpin
Donovan Charpin

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

Sonya Krishna
Sonya Krishna

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

Strawberry
Strawberry

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

Suresh Kamrushi
Suresh Kamrushi

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

Related Questions