Cant find the problem!

[Anon]

Not sure what I did wrong, trying to use MySQL and Php to set up a database...

Heres the php page for adding a new dataentry:

<?php
$db = mysql_connect("localhost", "root", "XXXXXXX");
mysql_select_db("members",$db);
$sql = "INSERT INTO employees (username, password, email, first, last, alt1, alt2, alt3, race,
class, gender, level, diety, head, neck, back, chest, arms, legs, face, waist, hands, ear1, ear2,
shoulders, wrist1, wrist2, finger1, finger2, range, melee1, melee2, feet, ammo, str, sta, agi,
dex, wis, intel, cha, attack, hp, mana, pr, mr, dr, fr, cr, lastupdate, imageid, comments) VALUES
('$username', '$password', '$email', '$first', '$last', '$alt1', '$alt2', '$alt3', '$race', '$class',
'$gender', '$level', '$diety', '$head', '$neck', '$back', '$chest',
'$arms', '$legs', '$face', '$waist', '$hands', '$ear1', '$ear2',
'$shoulders', '$wrist1', '$wrist2', ' $finger1', '$finger2', '$range', '$melee1',
'$melee2', '$feet', '$ammo', '$str', '$sta', '$agi', '$dex', '$wis',
'$intel', '$cha', '$attack', '$hp', '$mana', '$pr', '$mr', '$dr', '$fr',
'$cr', '$lastupdate', '$imageid', '$comments')";

$result = mysql_query($sql);

echo "Thank you! Information entered.\n";

?>

I do this and it shows "Thank you! Info Entered", but then i check the mysql:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 3.23.28-gamma

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql> use members
Database changed
mysql> SELECT * FROM members;
Empty set (0.01 sec)

And it Shows nothing.

Can anyone tell me what I did wrong? Im pretty sure its stomething stupid I am overlooking. Thanks!!

[Anon]

try
Select * from employees;
good day
gd

[Anon]

Woops, should be a table members, within the database members...I fixed that so it INSERTs into members, but i still get Empty set.

[Anon]

try
$result = mysql_query($sql)
or die("error inserting" . mysql_error());
to see if your generating any errors

good luck
gd

[Anon]

Still a problem...sighs
Heres the updated code, should work from what I can see:

The add.php file:

<?php
$db = mysql_connect("localhost", "root", "password");
mysql_select_db("members",$db);
$sql = "INSERT INTO members (id, username, password, email, first, last, alt1, alt2, alt3, race,
class, gender, level, diety, head, neck, back, chest, arms, legs, face, waist, hands, ear1, ear2,
shoulders, wrist1, wrist2, finger1, finger2, range, melee1, melee2, feet, ammo, str, sta, agi,
dex, wis, intel, cha, attack, hp, mana, pr, mr, dr, fr, cr, lastupdate, imageid, comments, epic, vp, st) VALUES
(0, '$username', '$password', '$email', '$first', '$last', '$alt1', '$alt2', '$alt3', '$race', '$class',
'$gender', '$level', '$diety', '$head', '$neck', '$back', '$chest',
'$arms', '$legs', '$face', '$waist', '$hands', '$ear1', '$ear2',
'$shoulders', '$wrist1', '$wrist2', ' $finger1', '$finger2', '$range', '$melee1',
'$melee2', '$feet', '$ammo', '$str', '$sta', '$agi', '$dex', '$wis',
'$intel', '$cha', '$attack', '$hp', '$mana', '$pr', '$mr', '$dr', '$fr',
'$cr', '$lastupdate', '$imageid', '$comments', '$epic', '$st', '$vp')";

$result = mysql_query($sql);

echo "Thank you! Information entered.\n";

?>

The Description of the table the data should be entered into:

mysql> describe members;
+------------+-------------+------+-----+---------+----------------+---------------------------------+
| Field | Type | Null | Key | Default | Extra | Privileges |
+------------+-------------+------+-----+---------+----------------+---------------------------------+
| id | tinyint(4) | | PRI | NULL | auto_increment | select,insert,update,references |
| username | varchar(20) | YES | | NULL | | select,insert,update,references |
| password | varchar(20) | YES | | NULL | | select,insert,update,references |
| email | varchar(50) | YES | | NULL | | select,insert,update,references |
| first | varchar(20) | YES | | NULL | | select,insert,update,references |
| last | varchar(20) | YES | | NULL | | select,insert,update,references |
| alt1 | varchar(30) | YES | | NULL | | select,insert,update,references |
| alt2 | varchar(30) | YES | | NULL | | select,insert,update,references |
| alt3 | varchar(30) | YES | | NULL | | select,insert,update,references |
| race | varchar(20) | YES | | NULL | | select,insert,update,references |
| class | varchar(20) | YES | | NULL | | select,insert,update,references |
| gender | varchar(10) | YES | | NULL | | select,insert,update,references |
| level | char(3) | YES | | NULL | | select,insert,update,references |
| deity | varchar(30) | YES | | NULL | | select,insert,update,references |
| head | varchar(50) | YES | | NULL | | select,insert,update,references |
| neck | varchar(50) | YES | | NULL | | select,insert,update,references |
| back | varchar(50) | YES | | NULL | | select,insert,update,references |
| chest | varchar(50) | YES | | NULL | | select,insert,update,references |
| arms | varchar(50) | YES | | NULL | | select,insert,update,references |
| legs | varchar(50) | YES | | NULL | | select,insert,update,references |
| face | varchar(50) | YES | | NULL | | select,insert,update,references |
| waist | varchar(50) | YES | | NULL | | select,insert,update,references |
| hands | varchar(50) | YES | | NULL | | select,insert,update,references |
| ear1 | varchar(50) | YES | | NULL | | select,insert,update,references |
| ear2 | varchar(50) | YES | | NULL | | select,insert,update,references |
| shoulders | varchar(50) | YES | | NULL | | select,insert,update,references |
| wrist1 | varchar(50) | YES | | NULL | | select,insert,update,references |
| wrist2 | varchar(50) | YES | | NULL | | select,insert,update,references |
| finger1 | varchar(50) | YES | | NULL | | select,insert,update,references |
| finger2 | varchar(50) | YES | | NULL | | select,insert,update,references |
| range | varchar(50) | YES | | NULL | | select,insert,update,references |
| melee1 | varchar(50) | YES | | NULL | | select,insert,update,references |
| melee2 | varchar(50) | YES | | NULL | | select,insert,update,references |
| feet | varchar(50) | YES | | NULL | | select,insert,update,references |
| ammo | varchar(50) | YES | | NULL | | select,insert,update,references |
| str | varchar(10) | YES | | NULL | | select,insert,update,references |
| sta | varchar(10) | YES | | NULL | | select,insert,update,references |
| agi | varchar(10) | YES | | NULL | | select,insert,update,references |
| dex | varchar(10) | YES | | NULL | | select,insert,update,references |
| wis | varchar(10) | YES | | NULL | | select,insert,update,references |
| intel | varchar(10) | YES | | NULL | | select,insert,update,references |
| cha | varchar(10) | YES | | NULL | | select,insert,update,references |
| attack | varchar(10) | YES | | NULL | | select,insert,update,references |
| hp | varchar(10) | YES | | NULL | | select,insert,update,references |
| mana | varchar(10) | YES | | NULL | | select,insert,update,references |
| pr | varchar(10) | YES | | NULL | | select,insert,update,references |
| mr | varchar(10) | YES | | NULL | | select,insert,update,references |
| dr | varchar(10) | YES | | NULL | | select,insert,update,references |
| fr | varchar(10) | YES | | NULL | | select,insert,update,references |
| cr | varchar(10) | YES | | NULL | | select,insert,update,references |
| lastupdate | varchar(30) | YES | | NULL | | select,insert,update,references |
| imageid | varchar(5) | YES | | NULL | | select,insert,update,references |
| comments | text | YES | | NULL | | select,insert,update,references |
| epic | varchar(5) | YES | | NULL | | select,insert,update,references |
| st | varchar(5) | YES | | NULL | | select,insert,update,references |
| vp | char(2) | YES | | NULL | | select,insert,update,references |
+------------+-------------+------+-----+---------+----------------+---------------------------------+
56 rows in set (0.01 sec)

The message I get after getting a "Information Entered, thanks!" (No Php or mysql error after submition)..This should have data:

mysql> SELECT * FROM members;
Empty set (0.00 sec)

[Anon]

Mispelled 1 word (1 letter), so it ruined everything..lol

Thanks anyone who looked, problem solved