inktri Posted May 3, 2008 Share Posted May 3, 2008 What's the most efficient algorithm for a function that tries to insert an entry... if the entry already exists, it returns the id of that already existing entry, else it inserts the new entry and returns the id of the new entry? Thanks for the help Quote Link to comment Share on other sites More sharing options...
pocobueno1388 Posted May 3, 2008 Share Posted May 3, 2008 <?php //Query database to check if entry already exists $query = mysql_query("SELECT entryID FROM table WHERE {condition}"); //If it does exist if (mysql_num_rows($query) > 0){ $row = mysql_fetch_assoc($query); echo "Entry already exists, the id is {$row['entryID']}"; //if it doesn't exist } else { //insert entry to DB $insert = mysql_query("INSERT INTO table (...) VALUES (...)"); $id = mysql_insert_id(); echo "New entry added, the id of the new entry is $id"; } ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.