Re: FN-FORUM: MySQL

date posted 14th November 2007 11:37

Hi Darren,

Something like this I think...

SELECT
PictureTypeID,
PictureTypeDescription
FORM
PictureType
WHERE
PictureTypeID IN (-- List of ids here)
ORDER BY
PictureTypeID

HTH!

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


On 14 Nov 2007 12:20:42 -0000, Lists - ARKAD Solutions wrote
> 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
>
>