SQL query not returning count value

Question

SQl query running to return the total count from the query.

this code works when running SQL with PHPmyAdmin

But on the page it is not displaying echo of the count ?

Not sure if I could have overlooked something here.

Many Thanks!

$sql2=mysql_query("SELECT count(*) 
FROM main_table LEFT JOIN houses ON main_table.housenumber = houses.housenumber AND main_table.streetname = houses.streetname
WHERE main_table.city='1'
group by main_table.city ORDER BY average DESC, houseID DESC, reviewID DESC;");

while($row=mysql_fetch_array($sql2))
{
    $count=$row['count'];
    echo $count;;
}

Zeeshan · Accepted Answer · 2013-10-13 08:05:33Z

1

Try this ....

$sql2=mysql_query("SELECT 
      COUNT(*) AS count
    FROM
      main_table 
      LEFT JOIN houses 
        ON main_table.housenumber = houses.housenumber 
        AND main_table.streetname = houses.streetname 
    WHERE main_table.city = '1' 
    GROUP BY main_table.city 
    ORDER BY average DESC,
      houseID DESC,
      reviewID DESC") ;

    while($row=mysql_fetch_array($sql2))
    {
        $count=$row['count'];
        echo $count;
    }

You have mistake in your query, you are not adding count in select as aliases, and below in while you are using aliases . Try this.

answered Oct 13, 2013 at 8:05

Zeeshan

1,68314 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pascalz · Accepted Answer · 2013-10-13 07:38:05Z

0

name your column :

...mysql_query("SELECT count(*) as count....

answered Oct 13, 2013 at 7:38

Pascalz

2,3581 gold badge24 silver badges25 bronze badges

Comments

lionheart98 · Accepted Answer · 2013-10-13 07:38:33Z

0

add SELECT count(*) as 'count' from ...

answered Oct 13, 2013 at 7:38

lionheart98

9881 gold badge11 silver badges25 bronze badges

Comments

Tata · Accepted Answer · 2013-10-13 07:38:57Z

0

try starting your query with :

SELECT count(*) as count ...

answered Oct 13, 2013 at 7:38

Tata

8099 silver badges20 bronze badges

Collectives™ on Stack Overflow

SQL query not returning count value

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related