mysql query error

[thara]

I need to create song's top 10 chart in my web site. Im going to add songs to chart using my downloaded system. I count all downloaded through my eb site. to create my top chart i need to find the download average for each song. I tried to find the average using this query but there was a error.

	$q = "SELECT song_id, song_title, added_date, datediff(now() - interval 7 day, added_date) as date, 
	downloaded/date as average FROM songs ORDER BY downloaded DESC";

 

can anybody help me..

any ideas are appreciated.

thanks..

 

[The Little Guy]

what is the error?

[thara]

Unknown column 'date' in 'field list'

[ZulfadlyAshBurn]

check your database if you have the column called date and its case-sensitive.

[thara]

I dont hava a column called date in my database.  i use it as a alias

[ZulfadlyAshBurn]

I seriously don't understand the query o.0

[The Little Guy]

Try this:

 

$q = "SELECT song_id, song_title, added_date, datediff(now() - interval 7 day, added_date) as date,  (downloaded / datediff(now() - interval 7 day, added_date)) as average FROM songs ORDER BY downloaded DESC";

[thara]

thanks dear.. you saved me from a big headache... Now its ok for me...

 

thank you very much again...