help a newbie with tables?

[Anon]

Allright, i need to add the following info to a table called \"users\". the value \"users\" is stored in the variable $table. There are 3 feilds in the table: id, username and password. Can anyone help me? Below is the code i used.

INSERT INTO $table (id, username, password) values (\"0001\", \"admin\", \"admin\");

thank you.

[spider_man]

Hi.

$result = mysql_query("insert into $table values set id=$id, user='$user', pass='$pass'");
if (!$result)
echo mysql_error();

Notice I've omited the quotes in the id filed, because it's a number type field for sure.
And I've also used doubled quotes to delimit the statement in order to parse the variable, not the literals.
That shuld work fine.

Consider learning about encryption for the pass.

Good luck.

[Anon]

thank you very much! that's helpfull!