[SilverDragonTears]

When a user names their pet and the name is already taken, how can I show that? I have it set where names are unique.

		// We are renaming an adoptable

			// Now we see if the adoptable actually exists...

			$stmt = $adopts->query("SELECT * FROM {$prefix}owned_adoptables WHERE owner='{$loggedinname}' and aid='{$id}'");
			$row = $stmt->fetchObject();

			if($row->aid == $id)
			{
				$image = getcurrentimage($id);

					if($more == "")
					{

						$article_title = "Rename {$row->name}";
						$article_content = "<img src='{$image}'><br />{$lang_rename}{$row->name}{$lang_rename2}<br />
											<form name='form1' method='get' action='myadopts.php'>
												<p>Adoptable Name: 
													<input name='more' type='text' id='more'>
													<input name='id' type='hidden' id='id' value='{$id}'>
													<input name='act' type='hidden' id='act' value='rename'>
												</p>
												<p>
													<input type='submit' name='Submit' value='Rename Adoptable'>
												</p>
											</form>";
					}

					else
					{
						// We are renaming the adoptable