Row Adding Problems

[Phantek]

Got another problem with my program.

I have a mySQL database, and setup a table with the values of id (auto_increment), username, password, and email.

I have used the following code to try and add a user through a PHP program:

PHP Code:

$sqlquery = "INSERT INTO $table VALUES ('',$username,$password,$email)";
mysql_query($sqlquery); 


Everything looked okay, until I realized a problem. It turns out that this will ONLY work if the values being entered are numbers. I found this out by accident while I was testing it out. If I enter text information for ANY of the fields, it will not create the new row. But if I just enter any numbers, even decimals, it will write the new row no problem.

The username, password, and email fields all are created as CHAR. Anyone able to help me out? Thanks.

[teknomage1]

you need to quote the fields just like you would in the sql client.

$sqlquery = "INSERT INTO $table VALUES ('','$username','$password','$email')";
mysql_query($sqlquery);

[Phantek]

Oh, wow. That was so noobish of me! lol

Thanks a lot for your help. Works perfect now.