title: PHP MySQL INSERT fails due to unique constraint
body: <p>On insert I am catching the unique constraint mysql_errno() 1062.</p>
  
  <p>This works fine but I want to find the existing row to re-instate or modify it.</p>
  
  <p>Is there are method to obtain the row id on insert fail?  I tried mysql_insert_id() but realised that would only return the row I'm inserting (or failed to insert) therefore, I get 0.</p>
  
  <p>Is there no option but to issue another mysql_query and simply perform a select on the duplicate value?</p>
  
  <p>I just want to make sure there is no better, quicker, more economical way to do this.</p>