Stupid Questions, but hey, Im retarded

Anon

mysql_connect("localhost", "rdsgtjj", "ndfgd1");
mysql_select_db("users");
mysql_query("INSERT INTO user (user,pw,email,joindate,name,addy1,addy2,city,state,zip,country,ref,referip,fries,confirmed,confirm)
VALUES ('$username',password('$pw'),'$email','$joindate','$name','$addy1','$addy2','$city','$state','$zip','$country','$ref','$REMOTE_ADDR','500','$pin','n')");

Is there anything wrong with the above script? It isnt updating mysql

kparker

Instead of writing the query inline as a parameter, say:

    $query = "insert into ... $city...";

That way, you can say

    echo "query = $query";

and see what the actual query is with the actual values in place.

Even more importantly, you're not trapping the error return from mysql_query. You should be saying:

    if (! mysql_query(...))
      echo "Oops: " . mysql_error();

That way mysql itself will tell you a lot of useful information about what went wrong.

raditha

It is possible that you have got the zip code field as a number in your database. But you are wrapping quotes around it. Sure way to confuse the db server.

You can also try running mysql_error() and echo out the result that tells you exactly what is going on.

and third if you have included your real username and password in that code snippet you better change it :-))

Anon

I'm wondering whether or not you should have the

password('$pw')

bit enclosed in single quotes as well. Remember, all arguments should have single quotes enclosing them and you can check this, as has been mentioned, by echoing your query string.

Anon

May be you should try not using password function directly on query but using it first like $pass = password('$pw'); and then use $pass on the query.