select and order by most common

[iHack]

Hey, I've got a table 'hits', I need to select 'song' from 'hits' in order of the value of 'song' most appearing (descending).

 

Any help will be greatly appreciated.

 

Thanks,

 

EDIT:  Latest MySQL (5)

 

[burnside]

need to use sum it like

 

 

$select = mysql_query("SELECT from 'hits' WHERE users='$var['users']' ORDER BY DESC limit 0, 50");

 

that is a idea it wont work cos im not that good but mite be what your looking for.

[iHack]

need to use sum it like

 

 

$select = mysql_query("SELECT from 'hits' WHERE users='$var['users']' ORDER BY DESC limit 0, 50");

 

that is a idea it wont work cos im not that good but mite be what your looking for.

 

I don't that will work, its just a SELECT, WHERE.

 

Sorry, the column name I need to ORDER and SELECT by is called 'song', my mistake

 

 

 

[burnside]

yeah it was just a example, Do you want a particula song of a list of them??

[iHack]

yeah it was just a example, Do you want a particula song of a list of them??

 

Nope. I want to get 'song' and and order by most occurrences of 'song', from 'hits'.

[burnside]

yeah it was just a example, Do you want a particula song of a list of them??

 

Nope. I want to get 'song' and and order by most occurrences of 'song', from 'hits'.

 

by occurrences you mean how many people downloaded them etc .... ?

[iHack]

Sort of, somebody opens a song it enters the song 'name' and user 'IP' into 'hits', the user can only do this twice to prevent refreshing and get a song popular.

 

I'm trying to make the popularity table of songs from the hits table.

 

James.

[burnside]

okay try this think its kinda what you want ;

 

 

$song = mysql_query("SELECT * FROM 'hits' WHERE song='song name or what ever' ORDER BY DESC 0, 50 );

 

think that is what you want if not sorry.

[iHack]

okay try this think its kinda what you want ;

 

 

$song = mysql_query("SELECT * FROM 'hits' WHERE song='song name or what ever' ORDER BY DESC 0, 50 );

 

think that is what you want if not sorry.

 

I don't want to specify a specific song name (so no WHERE, I think). I need to get a list of all song 'name's in order of the must occurring 'name' .

[burnside]

haha got what you mean sorry my fault 2 may beers try  :

 

 

$select = ("SELECT 'songs' from 'hits' ORDER BY DESC ");

sumit like that ?

[iHack]

haha got what you mean sorry my fault 2 may beers try  :

 

 

$select = ("SELECT 'songs' from 'hits' ORDER BY DESC ");

sumit like that ?

 

Simply put, no. :S

[burnside]

well have no idea what you want sorry  :'(

[trq]

SELECT song, COUNT(song) as total FROM hits GROUP BY song ORDER BY total;

[burnside]

i was trien hahaha see how easy you made it thorpe

[trq]

Hehe, I have no idea if that will work or not.

[iHack]

Hehe, I have no idea if that will work or not.

 

Thanks, that worked perfectly.

 

 

 

[burnside]

@thorpe what the count(song) do count how many times its pulled from the db?

[fenway]

Hehe, I have no idea if that will work or not.

Indeed it will.

[fenway]

@thorpe what the count(song) do count how many times its pulled from the db?

It counts the number of times a given song name shows up in your recordset... I don't know what "pulled from the db" means.

[burnside]

my wording isnt very good sorry. but yeah i understand now learned some thing new