codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    Show odd or even rows only

    5th June 2013

    MySql

    mysql codehaven category

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

    1
    2
    3
    4
     
    $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

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN