Something in MySQL

Anon

I'm new to MySQL. I've created a field called "PASSWORD" in my database. After I've added some records in this database, I browsed the database. But for the "PASSWORD" field, all the content in there are "password", although I've added this field with different password. Why ?? Thx

Anon

Sounds like your query was not correct.
What was your query?
and what query are you using to look at the table?

Anon

Any infinite number of reasons one would suppose. You might consider posting the code that you're using to INSERT and SELECT the database.

Anon

Here is my Script,

//===============================
define("STRUSERNAME", "root");
define("STRPASSWORD", "password");
define("STRHOSTNAME", "127.0.0.1");
define("STRDATABASENAME", "XXXDB");
define("STRTABLENAME", "XXXTABLE");

$strStmt = "CREATE TABLE STRTABLENAME (ROWID INT PRIMARY KEY AUTO_INCREMENT, NAME CHAR(255), PASSWORD CHAR(8))";
$strAddStmt = "INSERT INTO STRTABLENAME(NAME, PASSWORD) VALUES ('$strPlayerName', '$strPassword')";

$link = mysql_connect(STRHOSTNAME, STRUSERNAME, STRPASSWORD);
mysql_create_db(STRDATABASENAME, $link);
mysql_select_db(STRDATABASENAME, $link);
mysql_query($strStmt, $link);
mysql_query($strAddStmt, $link);
//===============================

If I have passed in $strPlayerName and $strPassword into the database, the password was not the password that I've inputed. It was "password" itself.

Anon

Kam Yuk Lun wrote:

$strAddStmt = "INSERT INTO STRTABLENAME(NAME, PASSWORD) VALUES ('$strPlayerName', '$strPassword')";

I'm not sure if it's a typo but shouldn't there be a space between STRTABLENAME and (NAME,PASSWORD). Things like this can cause weirdness ...