<jack> But i want to show my own message to the user for this error . </jack
hello Jack, do a check of the insert was successfull and redirect with php to your original page and include a error var e.g if (!mysql...) HEADER(LOcation:....file.php?error=mysqlfailed Then on your sign up page do an error check if (!empty($errror)) switch ($error){ case 'mysqlfailed': echo 'please choose a different user name...'; break; } Good luck, andy -- ---------------------------------------------------- http://www.globosapiens.net Global Travellers Network! "Jack" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Dear all > i made a Registration Form for user to input their Data, but i also had some > Field Check before the data can be insert to the Mysql_Database! > I had a question here, sometime the mysql shows the error : > "Duplicate Key for xxx" > I know what is this about, reguarding to my Registration Form, it mean the > Login Name is Duplicated! But i want to show my own message to the user for > this error instead the Mysql Error! It is meanness to show User the Mysql > Error, cause they won't understand it!!! > > Could Someone pls tell me how i can do this? > > > -- > Thx a lot! > Jack > [EMAIL PROTECTED] > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php