Re: Submitting data to MySQL database using HTML/PHP form

Daniel Brown wrote:

On Sun, Feb 20, 2011 at 14:11, Nazish Zafar<nazish@jhu.edu> wrote:

$insert = "INSERT INTO user_info (login, password) VALUES ("$login", "$password");

     You're using double-quotes to encapsulate your $insert variable

data, then never closing them. What's more, you're also using double-quotes to encapsulate each individual variable in the query. Rewrite $insert to this:

         $insert = "INSERT INTO user_info(login,password)

VALUES('".mysql_real_escape_string($login)."',"'.mysql_real_escape_string($password)."')";

Look at that one more time Dan. ;-) Donovan -- D Brooke