RE: FN-FORUM: MySQL

date posted 14th November 2007 11:39

Hi Sam,

Wont that just give him the first 10, not the actual 10 he wants?

Cheers!

--
Gary
http://www.garyshort.org


On 14 Nov 2007 12:25:03 -0000, 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
> >
> >
> --
> 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
>
>