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

    Re-number a column sequentially from 1 to ?

    25th August 2014

    MySql

    mysql codehaven category

    It really is this easy!
    Use this in your PHP code, or use direct, as sql.

    1
    2
    3
    4
    5
    6
    7
     
    mysql_query('SET @i = 0');
    $query = "UPDATE $listsentto SET todo_id=(@i:=@i+1);";
    mysql_query($query) OR die(mysql_error());
     
    echo "<br>Records Updated: ".$raf = mysql_affected_rows();
     

    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