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

    Inserted row – Show last row inserted by Mysql

    1st August 2014

    MySql

    mysql codehaven category

    Maybe you want to know what was the last inserted record to the database. Add this straight after the MySQL statement.

    1
    2
    3
    4
    5
     
    $inserted_row_id = mysql_insert_id();
     
    mysql_query("DELETE FROM reports WHERE id <> {$inserted_row_id} ") or die(mysql_error());
     

    Laravel version is here

    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