Limit 1

[sundance1980]

Hello. If I want to output id's 4 5 10 and 15 via a mysql_fetch_array. Would I use Limit. Something like what I ahve below?

$query="SELECT id, title, description FROM article ORDER BY id DESC LIMIT 4,5,10,15";
$result=mysql_query($query);
while($rst=mysql_fetch_array($result))

blah blah the rest.

Thanks in advance.

 

[towerbase]

Your SQL should look something like:

SELECT id, title, description
FROM article
WHERE id IN ( 4, 5, 10, 15 )
ORDER BY id DESC

Andrew
Hampshire, UK

 

[sundance1980]

Thanks works nice.