In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> I have a problem writing form data to a table in MySQL. I have an action.php file
> that it called when the information is submitted and it looks something like this:
> $connection = mysql_connect("@localhost","root", "password")
> or die ("The DataBase is Down!");
> mysql_select_db("web_feedback", $connection)
> or die ("I Can't connect at database!");
> $query_st_name = mysql_query("INSERT into name_email (col1) values($name)");
> $query_st_email = mysql_query("INSERT into name_email (col2) values($email)");
> mysql_close($connection); // Close this connection
> Thanks for submitting your name and e-mail, I will contact you soon to discuss your
> interest in more detail.
> I can tell the file is being called since the previous message appears in the
> But when I go to check out my table there are no records. Anyone see where this may
> be going wrong? I also set a php_error log path in the PHP.ini and I do not get any
> errors written there. I think it may be something else but not sure what...
> the site: www.best-it.biz
> the link: services
> thanks in advance!
Why are you doing two inserts? In any case, its likely that your error is
not having single quotes around the values you are trying to insert -
presumably they are char type fields? Use mysql_error after each of your
mysql_query to see if an error is being returned by mysql.
Quod subigo farinam
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php