necrotic — Sat, 14 Jun 2003 03:20:05 +0000

Okay, guess I'll rewrite them. I've been thinking about doing it, but it's been in the back of my mind.

mairving — Sat, 14 Jun 2003 02:45:03 +0000

You still need to have a way that the tables link together, generally known as foreign key. It looks like you need to rewrite your tables. You could put most of your info into one table, then split out a separate table for ratings and include a ratings_id in the first table that links to the ratings table. Probably would also have a table for authors. Then you could do a pretty easy select.

Keep in mind that one of the main goals of a database (besides a place to store your stuff) is to avoid redundant data.

necrotic — Fri, 13 Jun 2003 23:29:44 +0000

But then I'd have to do massive (I think) ammounts of PHP to get it to do what I want. I want only 10 from all 3 tables, a max of 10, not 30.

druagord — Fri, 13 Jun 2003 22:17:03 +0000

joined select will work when data on your tables are link together for exemple if you have a table for artist and a table for songs then you could get the top ten songs of the top ten artist. Now i might be wrong but i don't think there is a rellation between your tables so you have to do three querys to get the result you want here is the first one the others will be similar.

SELECT * FROM af_tabs ORDER BY views DESCENDING LIMIT 0,10