Stuve

No, it's not working.. I get "Invalid use of group function"...

Btw.. is it possible to get the MAX value from a SUM value? Something like this: SELECT MAX(SUM(a)) FROM stat GROUP BY id

Thanx a lot!

Why can't I order by SUM value? I get this error "Invalid use of group function". $sql="SELECT *, SUM(sm), SUM(gm), SUM(a), SUM(tp), SUM(um) FROM spelarstat WHERE lagid = '".$_GET['id']."' GROUP BY spelarid ORDER BY SUM(tp) DESC, SUM(gm) DESC, SUM(a) DESC, SUM(um)"; Help me please!!

Thanx !!  :)

Can someone help me what's the diffrens in using: $_GET[] $_POST[] $_REQUEST[] ??

Thanx a lot!! :D But one more question.. how to get [b]opendir('.');[/b] to open files in a subfolder??

Hey! I want to show a random picture on my start page. The picture is in sub folders. I have used this code to list the files but can somebody help me so only one randomed file is selected and so it only selects picture files from a selected sub folder. [code]<?php $rep=opendir('.'); while ($file = readdir($rep)) { if ($file != '..' && $file !='.' && $file !='' && $file !=is_dir($file)) { echo "<img src=\"$file\">"; } } closedir($rep); clearstatcache(); ?>[/code] Thanx!!