Jump to content

Archived

This topic is now archived and is closed to further replies.

Germaris

MySQL Syntax problem...

Recommended Posts

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 !

Share this post


Link to post
Share on other sites
[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 :)

Share this post


Link to post
Share on other sites
You should probably build an array and join it with ampersands.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.