[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