RE: FN-FORUM: MySQL

date posted 14th November 2007 12:03

No, the OP said he had a list of Ids he wanted.

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

On 14 Nov 2007 12:46:41 -0000, Sam M - www.wiredeyes.com wrote
> 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
> >
> >
> --
> 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
>
>