PHP Validation: check if value exists in mysql db

[Ben]

Hi Hannes,

Sure! If you need to construct a special query like that, you'll need to embed it in the PHP at the same spot as the ft_api_check_submission_is_unique function discussed above.

Since you've included the API, the database connection is already made for you, so you just need to do your query and extract the results, e.g.

Code:

$query = mysql_query("
  SELECT ... (query here)
");
$result = mysql_fetch_assoc($query); // assuming the query returns a single row
// check the contents of $result here

- Ben