select query problem

[thaidomizil]

Hi,

 

i'm trying to select some entries from my DB, i don't quite understand what's the problem here, i'm using this:

 

//Customers Online
$query = "SELECT COUNT(*) as Anzahl FROM customers WHERE status = 1";
$queryerg = mysql_query($query) OR die(mysql_error());
while($row = mysql_fetch_array($queryerg)){
  $customers_online = $row[0];
} 

 

Which works fine, now i want to select by country and i'm doing this:

 

//Customers DE
   $query = "SELECT COUNT(*) as Anzahl FROM customers WHERE country = 'de'";
   $queryerg = mysql_query($query) OR die(mysql_error());
   while($row = mysql_fetch_array($queryerg)){
     $customers_de = $row[0];
   }

 

Which doesn't work? If i print / echo $customers_de i just get a blank value, not even 0 or anything just blank.

 

Any help ?

[harristweed]

http://www.tizag.com/mysqlTutorial/mysqlcount.php

[thaidomizil]

Please don't post random links, read my question, answer on that, if you can't don't answer at all ? Thanks!

[PFMaBiSmAd]

If your $customers_de variable exists in the same scope where you printed/echoed it, you will get a zero if there where no matching rows or a number if there are matching rows.

 

What's your complete actual code with the print/echo in it that reproduces the problem, because I just tested the second code that you posted and it prints a zero if the query returned a zero value.

 

Do you have php's error_reporting set to E_ALL and display_errors set to ON so that php would report and display all the errors it detects in your code?