MySQL Syntax problem...

[Germaris]

Hi there!

This is a query of a PHP script I wrote which is supposed to return the number of rows for each different object present in the field nammed "list"

[code=php:0]
$query="SELECT list, count( * ) AS n FROM $table GROUP BY list HAVING ( n > 1 )";
//I don't know how to write the following
print (
// ? ? ? ? ?
);
[/code]

The result returned by this query is, FOR EXAMPLE, something like this

list    n
_____________
ai      72
bg      325
he      127
etc...

I want to send this result to my Flash file

&ai=72
&bg=325
&he=127
etc...

but I don't know to write it the right way !!!

Many thanks in advance for your help !

[SharkBait]

[code]
<?php
$str = "SELECT list, count( * ) AS n FROM $table GROUP BY list HAVING ( n > 1 )";
$query = msyql_query($str);

while($result = mysql_fetch_array($query, MYSQL_ASSOC)) {
  echo "{$result['list']} {$reseult['count(*)'} <br />";
}
?>
[/code]

Try that :)

[fenway]

You should probably build an array and join it with ampersands.