Counting amount of rows for a field within mysql query

strange1

I have a mysql table with a field called "id". "Id" is not unique, an integer and I would like to count the amount of rows having this "id" using PHP.

the html output should look like this:

<? echo amount of rows where id == 1 ?> rows have "id" == 1
<? echo amount of rows where id == 2 ?> rows have "id" == 2
<? echo amount of rows where id == 3 ?> rows have "id" == 3
<? echo amount of rows where id == 4 ?> rows have "id" == 4
<? echo amount of rows where id == 5 ?> rows have "id" == 5

and so on ...

can anyone help me out with this?

bernouli

<?php
for($a = 0; $a <=100 ; $a++) {
	$sql = mysql_query("Select count(*) from test where id = '".$a."'");
	$query = mysql_result($sql,0);
	if(!$query) {echo mysql_error();} else 
	echo "rows have ".$a." = ".$query."<br>";
}
?>

cgraz

bernouli,

Just curious, what does the 0 do in

$query = mysql_result($sql,0);

PHP.net say that's the int row, but i'm not sure what that does.

Is that why you can echo $query to get the count?

Cgraz

strange1

Originally posted by bernouli

<?php
for($a = 0; $a <=100 ; $a++) {
	$sql = mysql_query("Select count(*) from test where id = '".$a."'");
	$query = mysql_result($sql,0);
	if(!$query) {echo mysql_error();} else 
	echo "rows have ".$a." = ".$query."<br>";
}
?>

[/B]

that's exactly what I mean! one more thing, what if I would like to get the output of the first query result in one <td></td> and the second into another <td></td> (that is in another table somewhere else within my HTML code) ??

bernouli

@
yes, the 0 is row,
the full syntax mysql_result($sql,$row,$col);
but forget this syntax, mysql_fetch_array and mysql_fetch_row are much faster than result 🙂

<?php
include("dblib.lib");

for($a = 0; $a <=100 ; $a++) {

$sql = mysql_query("Select count(*) from test where id = '".$a."'");

$query = mysql_result($sql,0);

if(!$query) {echo mysql_error();} else 

$array[] = "rows have ".$a." = ".$query."<br>";

}

?>

then you have a variable $array, with it, you can simple add into your html tag

<html>
<td><?php echo $array[0]</td>
.
.
etc