Re: FN-FORUM: MySQL

date posted 14th November 2007 11:47

If you're only looking for the first or last ten, then you could also
add an ORDER BY , so in MySQL you'd have

SELECT PictureTypeID, PictureTypeDescription FROM PictureType ORDER BY
PictureTypeID ASC (or DESC ) LIMIT 10

ASC is Ascending - i.e. ID 1 2 3 4 ... 10 and DESC is Descending, i.e.
10 9 8 7 ... 1

You could do the same thing with PictureTypeDescription Asc = A-Z Desc =
Z-A .

Alex
http://www.ozbon.com


Sam M - www.wiredeyes.com wrote:
> Off the top of my head it is
>
> SELECT PictureTypeID, PictureTypeDescription FROM PictureType LIMIT 10
>
> MSSQL would be
>
> SELECT TOP 10 PictureTypeID, PictureTypeDescription FROM PictureType
>
> Regards
> Sam Morgan
> WiredEyes Media / ServWise Advanced Hosting
>
> tel (Uk): +44 (0)20 7100 2178
> tel (Italy): +39 070 773 6543
> web : www.wiredeyes.com / www.servwise.com
> ----
> umop ap!sdn w,! aw dlaH
> ----
> ----------------------------------------------------------------
> Great Hosting Sale, 50% off all ServWise
> hosting plans, use coupon code : HALFPRICE
> ----------------------------------------------------------------
>
>
>> -----Original Message-----
>> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Lists
>> - ARKAD Solutions
>> Sent: Wednesday, November 14, 2007 1:21 PM
>> To: FN-FORUM / [EMAIL REMOVED]
>> Subject: FN-FORUM: MySQL
>>
>>
>> Morning all,
>>
>> Blonde day at the moment and I can't think of how to do this....
>>
>> How do I do select statement to get a specified number of records from
>> a
>> table.
>>
>> What I have so far is...
>>
>> SELECT PictureTypeID, PictureTypeDescription FROM PictureType
>>
>> I have a list of PictureTypeID Values...which is what I want to
>> select..
>>
>> TIA
>>
>> Darren
>>
>>
>>
>> --
>> Freelancers, contractors earn more with Prosperity4
>> Call 0870 870 4414 or visit www.prosperity4.com
>> and benefit from Inland Revenue approved expenses today.
>>
>> To advertise here: http://www.freelancers.net/advertising.html
>>
>>
>>