Help with getting top 10 most visited

[cordoprod]

Hi.

 

I have a DB and my structure is like this.

nick | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | total

 

The weekdays only contain numbers like 2 and 4 ..

What i want to do is to plus them (+) ..

 

So i get the total of the weekdays, and then i want to get the 10 most visited and sort them like this:

1. username1

2. username2

 

and so on..

 

Do you understand?

[pocobueno1388]

Try

 

<?php

$query = "SELECT nick, (Monday + Tuesday + Wednesday + Thursday + Friday + Saturday + Sunday) AS added FROM table_name
ORDER BY added DESC LIMIT 10";

$result = mysql_query($query)or die(mysql_error());

$i = 0;
while ($row = mysql_fetch_assoc($result)){
   echo $i .'. '.$row['nick'].'<br />';
   $i++;
}

?>

[cordoprod]

Try

 

<?php

$query = "SELECT nick, (Monday + Tuesday + Wednesday + Thursday + Friday + Saturday + Sunday) AS added FROM table_name
ORDER BY added DESC LIMIT 10";

$result = mysql_query($query)or die(mysql_error());

$i = 0;
while ($row = mysql_fetch_assoc($result)){
   echo $i .'. '.$row['nick'].'<br />';
   $i++;
}

?>

 

Thanks =)

[cordoprod]

Just one more thing..

 

Is it possible to split it up in to sides so it looks more like this:

 

1. username    6. username

2. username    7. username

3. username    8. username

4. username    9. username

5. username    10. username

[.josh]

Yes.  There are a hundred ways you could make it look like that. I suggest choosing the one most consistent with the rest of your page design.

[cordoprod]

Could you show some code?

[cordoprod]

Does anyone know?

[AndyB]

Does anyone know?

 

I suspect that lots of people who have looked at your problem have ideas on how to do that.  Why don't you show us your code effort - we're here to help you help yourself, not to write code for you.