[thelist] Doh! question for MySQL

walker walker at sdproductions.com
Wed Feb 14 00:13:47 CST 2001


I guess I should be more clear- the table is has a primary key 
(orderitemid) that is auto-numbered.. the table contains items that have 
been ordered from a website.

The client wants to show on the front page the last ten items that were sold...

So I was thinking that I would write a query to pull the latest ten - but I 
don't want to do it on a timestamp, in case nothing gets sold in awhile.....

thanks for your help

-w


At 08:10 PM 2/13/2001 -0800, you wrote:
>At 08:06 PM 2/13/2001 -0700, you wrote:
>
>>I'm looking for a little sql syntax on mysql.
>>
>>I need a way to select the last 10inserts into a db table. I know this is 
>>probably simple, but I can't seem to get it.
>
>A little more info about how your table is constructed would be helpful. 
>However, if you don't have an identity/auto-number field or an 
>insert-date-time field your hosed. ;-)
>---
>Anthony Baratta
>President
>Keyboard Jockeys
>
>
>---------------------------------------
>For unsubscribe and other options, including
>the Tip Harvester and archive of TheList go to:
>http://lists.evolt.org Workers of the Web, evolt !

_________________________________________
walker fenton
walker at sdproductions.com
303.722.5473





More information about the thelist mailing list