Help with this sql query

golfinggod

Hi
Can anyone see a problem with this code. I am trying to count all the rows from the table where the value of Java is == True


$sql = mysql_query("SELECT Id COUNT(*) FROM vis_java WHERE Java = True GROUP BY Id ") or die (mysql_error()); 

$result = mysql_db_query($sql);

$thisrow=mysql_fetch_row($result);

echo $thisrow;

I get this error

You have an error in your SQL syntax near 'COUNT(*) FROM vis_java WHERE Java = True GROUP BY Id ' at line 1

Taffy

Hi,

try this instead of your query

$sql = mysql_query("SELECT Id COUNT(Id) as result FROM vis_java WHERE Java = TRUE GROUPE By Id ")

now the returning object will be e table with the following information

id / result
1 5
3 2

so in the table there was found 5 times the combination id = 1 and Java = true

hope that is what you are looking for

mfg Taffy

$sql = mysql_query("SELECT Id COUNT(*) FROM vis_java WHERE Java = True GROUP BY Id "

Taffy

oups .. forgot a ","

Originally posted by Taffy

$sql = mysql_query("SELECT Id, COUNT(Id) as result FROM vis_java WHERE Java = TRUE GROUPE By Id ")

so hope it's now correct

golfinggod

thanks