How can I make it so that instead of the ugly error that comes up I can have a custom message for error code 141? Error 141 means a duplicate is being added to the database, I want it to say something like "That username is already taken!" instead of the ugly "Duplicate entry 'blablabalavl' for key 2

I'm not sure, but I think you change the place in you PHP code from:

[php]<?php
...
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
...
?>[/php]

To:

[php]<?php
...
$result = mysql_query($query) or die('That username is already taken!');
...
?>[/php]

But I don't know for sure so don't quote me on this

Yes, but that means that string will display no matter what the error is, I need it to display different things depending on the error.

Then try something like this:


Make a function that takes all kinds of different errors and returns the user to the home page and shows the error. In this case it is a username error so that is the value we will pass the function.

[php]
<?php
...

if (!$result) {
gotohomepage_showerror('USERNAME_ERROR');
exit;
}

...
?>[/php]


The function could also except other values:

[php]
gotohomepage_showerror('DB_CONNECT_ERROR');
gotohomepage_showerror('PAGE_ERROR');
gotohomepage_showerror('GENERAL_ERROR');
ect...
[/php]

I ended up already doing that kind of thing, but thanks anyway, others may find it usefull.