Duplicate Character Names[Solved]

[MikeD]

Well, obviously a little rusty from my 2 weeks away .

Had to create a new DB since I forgot to save mine on the flash drive, made table names and a few column names differently. Now I am stuck on this little gem.

I've tested to make sure the $warrior variable was valid, which it is, it comes from the register form.

Code: Select all

$warrior=$_POST['warrior'];

$isplayer="SELECT * from characters where character=$warrior]";
$isplayer2=mysql_query($isplayer) or die("Could not query players table");
$isplayer3=mysql_fetch_array($isplayer2);

Keeps coming up with the die statement "Could not query players table", when trying to create a player. This worked just fine on my old laptop and with the old DB.

[SpiritWebb]

Well, obviously a little rusty from my 2 weeks away .

Had to create a new DB since I forgot to save mine on the flash drive, made table names and a few column names differently. Now I am stuck on this little gem.

I've tested to make sure the $warrior variable was valid, which it is, it comes from the register form.

Code: Select all

$warrior=$_POST['warrior'];

$isplayer="SELECT * from characters where character=$warrior]";
$isplayer2=mysql_query($isplayer) or die("Could not query players table");
$isplayer3=mysql_fetch_array($isplayer2);

Keeps coming up with the die statement "Could not query players table", when trying to create a player. This worked just fine on my old laptop and with the old DB.

You have a [ after your $warrior call, remove that and try again!!

[Chris]

Well, obviously a little rusty from my 2 weeks away .

Had to create a new DB since I forgot to save mine on the flash drive, made table names and a few column names differently. Now I am stuck on this little gem.

I've tested to make sure the $warrior variable was valid, which it is, it comes from the register form.

Code: Select all

$warrior=$_POST['warrior'];

$isplayer="SELECT * from characters where character=$warrior]";
$isplayer2=mysql_query($isplayer) or die("Could not query players table");
$isplayer3=mysql_fetch_array($isplayer2);

Keeps coming up with the die statement "Could not query players table", when trying to create a player. This worked just fine on my old laptop and with the old DB.

You have a [ after your $warrior call, remove that and try again!!

It's actaully a ].

Code: Select all

$warrior=$_POST['warrior'];

$isplayer="SELECT * FROM `characters` WHERE `character`='$warrior'";
$isplayer2=mysql_query($isplayer) or die("Could not query players table");
$isplayer3=mysql_fetch_array($isplayer2);
 

[MikeD]

Nope doesn't work, that was just a typo, tried it with the post, didn't work either.

[SpiritWebb]

Are you including your connect file?

Code: Select all

<?php include_once "connect.php"; ?>

[MikeD]

yessir

[SpiritWebb]

At the end of your "Could not query players table."

Put a . mysql_error().

Code: Select all

$warrior=$_POST['warrior'];

$isplayer="SELECT * from characters where character=$warrior]";
$isplayer2=mysql_query($isplayer) or die("Could not query players table" . mysql_error());
$isplayer3=mysql_fetch_array($isplayer2);

To better see whats going on

[MikeD]

Could not query players tableYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=test' at line 1

[Chris]

Code: Select all

$isplayer="SELECT * FROM `characters` WHERE `character`='" . mysql_real_escape_string($warrior) . "'"; 

Seems like it's an error caused by injection.

[Ark]

near '=test' at line 1

is that supposed to be like 'test' instead oof '=test'. xD

$isplayer="SELECT * from characters where character='$warrior'";