CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Beginner: Re: [BillKSmith] HOw to write sql for get top 100 record in CGI perl script?: Edit Log



wickedxter
User

Nov 7, 2013, 6:39 PM


Views: 1665
Re: [BillKSmith] HOw to write sql for get top 100 record in CGI perl script?

i've done something close to what you want before

u need to lookin to the sql: ORDER BY and LIMIT

EX:

select * from table where money>=500000 order by asc limit=100


(This post was edited by wickedxter on Nov 7, 2013, 6:41 PM)


Edit Log:
Post edited by wickedxter (User) on Nov 7, 2013, 6:41 PM


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives