Reply
Old 06-24-2009, 03:20 AM SQL script
Super Talker

Posts: 105
Location: Alberta, Canada
Trades: 0
Hey Im looking for an sql script that will shop the top five entrys regarding a certain column. In my case, its a auction site, and i want the script to show the top 5 sellers. the tabel is called thrillbid_users, and the table that shows how much items they sold is items_sold. A site that uses the exact same auction script as me is webidz.com. Im looking for it just like on the right middle of the page, thanks alot.
d1zl3 is offline
Reply With Quote
View Public Profile
 
 
When You Register, These Ads Go Away!
Old 06-24-2009, 04:37 PM Re: SQL script
NullPointer's Avatar
Will Code for Food

Latest Blog Post:
Easy PHP Search with Opera
Posts: 1,048
Name: Matt
Location: Irvine, CA
Trades: 0
Code:
SELECT * FROM thrillbid_users ORDER BY items_sold DESC LIMIT 5;
__________________
Tinsology | How to Post Code | EverythingDev
NullPointer is offline
Reply With Quote
View Public Profile
 
Old 06-24-2009, 05:19 PM Re: SQL script
Super Talker

Posts: 105
Location: Alberta, Canada
Trades: 0
[quote=NullPointer;887335]
Code:
SELECT * FROM thrillbid_users ORDER BY items_sold DESC LIMIT 5;
is that all i put because it doesnt seem to be working.
d1zl3 is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to SQL script
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 



Page generated in 0.10439 seconds with 13 queries