Mysql error posting

ShoulderChip

When I try and insert a record into a table via a website, it is at times giving me a duplicate error notice.

I set this up to avoid duplicates, and I am happy that this is happening

Is it possible however to show for me to type my own content, instead of the error code been the only thing on the screen?

I have been searching all over google but have found nothing,
I must be using the wrong keywords,

cheers.

Liam Byrne

ShoulderChip wrote: »

When I try and insert a record into a table via a website, it is at times giving me a duplicate error notice.

I set this up to avoid duplicates, and I am happy that this is happening

Is it possible however to show for me to type my own content, instead of the error code been the only thing on the screen?

I have been searching all over google but have found nothing,
I must be using the wrong keywords,

cheers.

Yup - do a "SELECT" statement before you do the insert, and only run the insert if the number of rows returned is 0.


SELECT * from TABLE WHERE id=key_id
:
if ($numRows==0) {
INSERT INTO TABLE.....
} else {
PREPARE AND SHOW YOUR OWN ERROR MESSAGE
}

Eoin

If MySQL is returning a specific error number, you could also trap this with some try/catch code.