[Resolved] Load last inserted MySQL info into PHP

[rastem]

Hello all!

I'm having a touch of trouble figuring out how to check for duplicates in a MySQL query. The idea is to have a visitor input information and compare the input info against the database to see if there are any duplicates. If there are, direct them to one page, if there aren't direct them to another.

Assume the table has the following fields:

ID <- primary auto increment
name
address
phone
email

If there was a way to query the DB for the last ID put in, perhaps that would work, not sure. Any help would be appreciated!

Ras.

[drawmack]

Originally posted by rastem
ID <- primary auto increment
name
address
phone
email

<?php
function exists($table,$field,$value,$quoted=0) {
 $sql = "SELECT $field FROM $table WHERE $field=";
 if($quoted) {$sql .= "'" . addslashes($value) . "'";}
 else {$sql .= $value;}

 $query = @mysql_query($sql);
  if($query) {
   if(@mysql_num_rows($query) > 0) {return 1;}
   else {return 0;}
  } else {
    echo "QUERY ERROR: " . mysql_error() . "<br>\n";
  } //end if
  return 0;
} //end exists
?>