ok here we go: Table 1 user_table id points
Table 2 reports report_id user_id rating The goal is to associate every user extra 50 points if he has a top 10 report. Top 10 report means the 10 reports with the highest ranking. This value is always changing, thats why I did not include it to the other points. Now that we have the users with the additional points we could add them to the total points of the user and then find out the 5 users with the highest total points. Thats the theory, but how to achieve this in real live?? Thanx for any idas, Andy "Analysis & Solutions" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Please post the relevant table and field names. > > --Dan > > -- > PHP classes that make web design easier > SQL Solution | Layout Solution | Form Solution > sqlsolution.info | layoutsolution.info | formsolution.info > T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y > 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
