RE: FN-FORUM: MySQL

date posted 14th November 2007 13:10

Thanks all... its working now...

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Juraj
Seffer
Sent: 14 November 2007 13:12
To: FN-FORUM / [EMAIL REMOVED]
Subject: Re: FN-FORUM: MySQL


On 14 Nov 2007 12:21:35 -0000, Lists - ARKAD Solutions
[EMAIL REMOVED] 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
>

If you want to select more than one records based on ID:
SELECT PictureTypeID, PictureTypeDescription FROM PictureType WHERE
PictureTypeID IN (list of IDs separated by comma)

For just one particular record:
SELECT PictureTypeID, PictureTypeDescription FROM PictureType WHERE
PictureTypeID = '$id'

Jay
--
Web Developer
Cathill Design
Web Development | Graphic Design | Multimedia
www.cathill.com/portfolio

--
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