Show odd or even rows only

This code will show just the even or odd rows using mysql

$result = mysql_query("SELECT * FROM test where (id,0) in (select id,
mod(id,2) from test);");  // change (id,0) to (id,1) to get odd or even rows

// id is field