[Adrian Schneider]

just 4 and 6? or 2, 4, 6, 8, etc?

Anyway, something like this could work for your query [sql]SELECT *
FROM `test`
WHERE `id` IN (2,4)[/sql]Note this is id 2 and 4, not necessarily rows 2 and 4.

You can narrow the results in MySQL or PHP... here is a PHP example to show every second row...

PHP Code:

$counter = 0;
while ($row = mysql_fetch_assoc($result)) 
{
    if (++$counter %2 == 1)
    {
        continue;
    }
    // echo your stuff here
}