I have a MySQL database, with one table: tblquestion.
The table has a unique index on finQuestion (the question #).
I know the unique index works, because if I try to run an insert query in the msqlld window, it rejects it and says its a duplicate entry for the above key.
So, I ran some PHP code with the following line in it:
$vrrQuery = mysql_query($vtxSqlInsert, $vrlMySql) or die("Couldn't Insert Record<br>\n".mysql_error());
The connection was alright, database selection was alright.
This block of code I'm talking about inserts a bunch of questions into tblquestion with the #'s from 1-60 (finQuestion).
If I call the php code again, it DOES NOT DIE AT THE INSERT STATEMENT?
It just keeps going happily!
So, I'm stunned.
I'm used to errors happenning in MS Access, so I wanted to see what the MySQL error fed back to PHP would look like.
Can somebody tell me what is going on?
I wanted to get a head's up to see how to trap for duplicate entries in future forms' I design.