Allow different spelling of names

[SilverDragonTears]

If someone has the name Holly for an adopt, how can I make it so that another person can use HoLLy, or some other variation of the same name?

[Abronsyth]

Not that I can answer this...but are users currently unable to give their pet the same name of another existing pet..?

[SilverDragonTears]

If you have it set up that way which I do. And I think that it's default.

[Hall of Famer]

You can use strcmp() function to validate the name of an adoptable with another. This one is case sensitive, so Adopt and adopt are not the same.

[SilverDragonTears]

Where do I place that at?

[Hall of Famer]

Place it where it validates adoptables name.

[SilverDragonTears]

I tried this but I don't think it's correct as it didn't work.

else{
                    $stmt = $adopts->query("SELECT * FROM ".constant('PREFIX')."owned_adoptables WHERE name='{$more}'");
                    $row = $stmt->fetchObject();
                    if(!is_object(strcmp($row))){ 
                       // The name has not yet been used, we are good to go!

[Hall of Famer]

Of course its not correct lol. You dont know how to use the strcmp() function dont ya? It accepts two arguments, not one. The arguments have to be strings, not objects. Try this:

PHP Code:

$name = $adopts->query("SELECT name FROM ".constant('PREFIX')."owned_adoptables WHERE name='{$more}'")->fetchColumn();
if(!strcmp($name, $more)){
    // The name has not be used...
}
else{
    // Show error message
} 


[SilverDragonTears]

Rawr, I'm not putting it in the right place :(

$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.

[Hall of Famer]

umm are you sure the query is executed correctly? I mean, do the variables $id and $more exist? If so, what values do they hold? Use var_dump($id) and var_dump($more) to validate their values. If one of them turns out to be blank or null, you know the problem.