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

    Update Else Insert

    20th May 2014

    MySql

    mysql codehaven category

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
     
    $result = mysql_query("SELECT * FROM table1 WHERE title_1 ='$title_1' ");
     
    if( mysql_num_rows($result) > 0) {
        mysql_query("UPDATE table1 SET time = '$time' WHERE title_1 = '$title_1' ");
    }
    else
    {
        mysql_query("INSERT INTO table1 (title_1) VALUES ('$title_1') ");
    }
     

    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