RE: FN-FORUM: MySQL

date posted 14th November 2007 11:54

I assumed that's what he/she wanted to do "get a specified number of records
from a table" not get a specific set of record ids.

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 Gary
> Short
> Sent: Wednesday, November 14, 2007 1:32 PM
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: RE: FN-FORUM: MySQL
>
>
> 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
> >
> >
> --
> 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
>
>