Rawr, I'm not putting it in the right place :(
Code:
$name = $adopts->query("SELECT name FROM ".constant('PREFIX')."owned_adoptables WHERE name='{$more}'")->fetchColumn();
if(!strcmp($name, $more)){
// The name has not yet been used, we are good to go!
$adopts->query("UPDATE ".constant('PREFIX')."owned_adoptables SET name='{$more}' WHERE aid='{$id}' and owner='{$loggedinname}'");
It says it worked but it didn't change the name.