MYSQL_NUM_ROWS

jacopo

Hello,

Need help for a stupid mySQL problem.
I've a table in a db called report
It stores all searches done in a search engine based on a Database.
When someone does a search the string he's searched for goes in table report.
Now, I need to create a back office page where I can read all searches done ordered by number
I.E. if sport has been searched for 40 times and sex for 30 times it should return me
sport (40)
sex (30)
based on the number of rows in which it find sport.

I've tried this

<?
$db = mysql_connect("$mysqlserver","$mysqluser","$mysqlpass");
mysql_select_db($dbname,$db);
$query = mysql_query("SELECT Count(string),string FROM report GROUP BY string;");
while($row=mysql_fetch_array($query)){
print ("".$row["string"]." \n");

}
?>

but it returns me string only without counting for string number....
Any ideas?

thanks

ajwws

1001 studio wrote:

Hello,

[snip]

Now, I need to create a back office page where I can read all searches done ordered by number

[snip]

I've tried this

$db = mysql_connect("$mysqlserver","$mysqluser","$mysqlpass");

mysql_select_db($dbname,$db);

$query = mysql_query("SELECT Count(string),string FROM report GROUP BY string;");

while($row=mysql_fetch_array($query)){

print ("".$row["string"]."\n");

}

but it returns me string only without counting for string number....

Any ideas?

I'm still new to MySQL myself, but it looks to me like you're only telling it to print string. Have you tried adding .$row["Count"]. to your print statement?

A.J. Wilson

Anon

Try...
$row = mysql_fetch_assoc(mysql_db_query("db_name","SELECT COUNT(*) AS count,string FROM report GROUP BY string;"));
print ("$row[count]");

jacopo

Hello,

It return all strings with unique count number
I.E.
sport 474
art 474
culture 474
sex 474
ecc..

sam wrote:

Try...
$row = mysql_fetch_assoc(mysql_db_query("db_name","SELECT COUNT(*) AS count,string FROM report GROUP BY string;"));
print ("$row[count]");