Re: Submit form Problems

[Jonathan Stephens]

2 problems:

1. Syntax error in the INSERT. See http://dev.mysql.com/doc/mysql/en/INSERT.html

2. You need to insert the values held in the POST variables. So your query should use those variables.

Instead of this:

$query = "INSERT INTO ts1news (ts1_title, ts1_subtitle, ts1_summary, ts1_story)";

try this:

extract($_POST); # see php.net/extract for info
$query = "INSERT INTO ts1news VALUES ('$ts1_title', '$ts1_subtitle', '$ts1_summary', '$ts1_story')";

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle