Displaying the top 4 mysql database's

[timmy2]

I was wondering how I would Display the top 4 mysql database's?

 

I was thinking of using the <a href="http://us3.php.net/switch">switch function</a> but I don't know what the variable would be

 

Can someone help me?

[trq]

Do you mean the top 4 records from a database table?

 

SELECT fld FROM tbl ORDER BY fld2 DESC LIMIT 4;

 

Where fld2 is satisfies the criteria as TOP.

[timmy2]

but will that just show the databse's ?

I would like it to show diffrent text for each database

[calabiyau]

http://www.desilva.biz/mysql/listdbs.html

 

maybe this is what you're looking for?

[trq]

You need to be alot clearer in the explination of what you actually want. You also might want to look up the difference between a database (holds tables), a table (holds records), a record (holds fields) and a field (holds data).

 

Once you've got them down, you may need to rephrase your question.

[timmy2]

I don't know how to do this

Basicly I want to have 20 groups of 3.

Php or mysql adds all the rows in each group  I define the groups from table's eg.(table1, table2, table3 would be a group) then it checks which groups has the most rows and display's the 4 groups that have the most row's

and I echo something diffrent about each group

 

hope this makes sense

[Barand]

hope this makes sense

 

Afraid not.

[timmy2]

what does not make sense?

[Barand]

What does?

 

You know what your data looks like and how it's structured. We'd have to be clairvoyant to know what you are talking about.

[timmy2]

Ok I'll try again

I define 20 groups.

In each group there are 3 tables

php or mysql counts all the rows in one group (3 table's)

each group echo's something diffrent

the 4 groups that have the most row's echo the things I've defined.

 

[Barand]

Q1. Why is the data spread over 60 tables?

 

Q2. How do you know which 3 tables belong to each of the 20 groups?

[timmy2]

Q2.

I would define it Group1 (table1, table2, table3);

[Barand]

this should help

 

<?php   
function rowCount ($tablename)
{
    $res = mysql_query ("SELECT COUNT(*) FROM `$tablename`");
    return mysql_result($res, 0,0);
}

$count = rowCount('Table1');


?>