cannot get a basic INSERT command to work..

[Bambers]

hi all

i cannot get the following command to work, any ideas?

$sql_query = "INSERT INTO 'members' (uname, fname, lname, pword, email) VALUES ('$uname', '$fname', '$lname', '$pwordmd5', '$email')";

its not an issue with my db connections, as i have other sql staments working in the script

many thanks

[Motoma]

Please read the Posting Guidelines before posting a question.
Please follow my directions, post the error message you receive.

hi all

i cannot get the following command to work, any ideas?

$sql_query = "INSERT INTO 'members' (uname, fname, lname, pword, email) VALUES ('$uname', '$fname', '$lname', '$pwordmd5', '$email')";

its not an issue with my db connections, as i have other sql staments working in the script

many thanks

[Bambers]

i dont receive any errors

[code green]

cannot get the following command to work, any ideas?

[PHP]$sql_query = "INSERT INTO 'members' (uname, fname, lname, pword, email) VALUES ('$uname', '$fname', '$lname', '$pwordmd5', '$email')"; [/PHP] This is not a command. It is a string variable.

i dont receive any errors

Well you should if you are writing good code. Like Motoma said. What is the error?

[Motoma]

i dont receive any errors

You get no errors at all, even when you put the ini_set headers and the "or die(mysql_error ());" at the end of your query?

If that is the case, your INSERT statement is working. Or you aren't executing the query.