LEARN PHP !!!!
No seriously if you are interested in having your own site(s) you really need to know the basics of PHP and MySQL (if your using a PHP and MySQL driven source that is before someone says what if i use ASP lol)
There are many ways to do this ... For a start you already have the basic construct of each page to save you typing them out just delete the **** in the middle (i.e. that pages content) and add whatever you want.
One way to do this which is probably easiest for you is to
have a little play and you'd be able to do it this way easily.. if you want a top ten list rather than just the top user of a certain search then change the limit to 10 and use a while loop to echo the results. You could also do the entire top lists in one query using JOIN's ect but ive not seen an optimised wap site yet so you obviously wouldnt be bothered about using JOIN's for optimisation.Code:$res = mysql_query("SELECT * FROM table ORDER BY field DESC LIMIT 1"); $arr = mysql_fetch_row($res); echo $arr[0];
I hope thats wat you mean by a top list anyway... i know it aint what you asked for and no matter what you reply the chances of you actually having a go yourself are 1 in a million but there are the odd few people out there that prefer to learn how to code rather than snatch scripts or copy and paste snippets.



LinkBack URL
About LinkBacks
Reply With Quote



Bookmarks