[RESOLVED] how to get db to send me an email when number is reached?

[rikmoncur]

I've got a questionnaire online and the responses get saved to a database.

When the database has received 100 responses, I'd like to get sent an email letting me know.

I can't think how to do it tho... any advice anyone?

[Roger_Ramjet]

After each new record is saved, count the rows and send the email when it equals 100.

I suppose that some databases with stored procs and triggers might be able to do that, but just extending you php script to test after the insert seems easiest to me.

[rikmoncur]

thanx for the pointer! I've have a fiddle with your suggestion this is what I've come up with:

// get the total number of rows
$totalRows_Recordset4 = mysql_num_rows($Recordset4); 

// set when you want to be notified
if (($totalRows_Recordset4 == 25) || ($totalRows_Recordset4 == 50) || ($totalRows_Recordset4 == 100)) 

// if a specified number of rows have been reached then send an email with that number
{mail("[e-mail]","questionnaire results","replies so far ". $totalRows_Recordset4,"From: [e-mail]\n");}