last question, i promise, lol

[matzomeal]

$sql = "INSERT INTO $dbname.$tblname (name,password,email,user_id) VALUES($username,$pass,$email,NULL)";

that code isn't working. anyone know why?

 

[leafypiggy]

unless you're calling

mysql_query($sql);

you need:

$sql = mysql_query("INSERT INTO $dbname.$tblname (name,password,email,user_id) VALUES($username,$pass,$email,NULL)");

 

[lemon-tree]

Are all of your variables defined? I.e. $dbname

 

[misson]

Another one: can field user_id be NULL? What's the definition for the user_id column?

 

[ichwar]

I've got a question, are table names case sensetive? What I mean is: is ichwar going to be different from ICHWAR or IcHwAr?

 

[zubair12]

off course php is case sensitive

 

[ichwar]

off course php is case sensitive

ok, humm, that's not good, oh well. I'll have to find a work around.

 

[garrettroyce]

ok, humm, that's not good, oh well. I'll have to find a work around.

php has the function strtolower() to make all letters lowercase and mysql has the function LOWER() which does the same.

 

[xav0989]

matzomeal, what do you mean by not working?

If you mean not executing, then try as leafypiggy said.
If you mean that you get a php error stating that a variable is not defined, then define all you variables, as lemon-tree said.
If you are getting a false result from mysql_query, then do a var_dump on the sql variable, and copy the value in PhpMyAdmin. This will point out any error in your query.