Re: [PHP] Sort problem

Anyone know a smart way to order file names? Nope, but I know a natural way: http://ca.php.net/manual/en/function.natsort.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Sort problem

Wow! Thank you! I completely forgot this method! Regards, Igor Escobar *Software Engineer * + http://blog.igorescobar.com + http://www.igorescobar.com + @igorescobar http://www.twitter.com/igorescobar On Wed, Sep 14, 2011 at 12:02 PM, Marc Guay marc.g...@gmail.com wrote: Anyone know a

Re: [PHP] sort problem

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

Re: [PHP] sort problem

If he has a top-ten report... is that a one-off thing? Or is it a weekly thing? Or is that every time his report get's into the top ten (in which case hovering around 10-11 would be the best bet!!)?? You need to decide WHEN the user is awarded the 50 points for being in the top ten. For

Re: [PHP] sort problem

On Thu, Jul 11, 2002 at 11:30:16AM +0200, andy wrote: 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

RE: [PHP] sort problem

I'm not sure if I completely understand what you're asking, but It sounds like one table has user information. The second table has a record for each user and a field for the total number of points of each user. Something like this: Users (Table 1) - ID Name Address etc.

Re: [PHP] sort problem

Ed, Andy Andy said that the points were in the users table. Table layouts would have been useful. It sounds to me as though the users table has not got its points up to date and needs updating from the scores table first. Then do the select on just the users table. My 2p (pence, I'm in the

Re: [PHP] sort problem

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