Posted by Philip Hallstrom on 09/09/05 04:41

> Still learning, so sorry if this sounds really simply noobish. But as I
> understand things currently this should work. But doesn't. I've been
> looking over tutorials but just don't see whatever the problem is.
>
> I created a simple table with the following fields (in order)
> tc_id (auto nmbr)
> lname
> fname
> machine_name
> email_addr
> problem
> date_time_submitted (timestamp)
>
> And I'm trying to run this insert from form input.
>
> $username="somename";
> $password="somepass";
> $database="somedb";
> $table="sometable";
> mysql_connect(localhost,$username,$password);
> @mysql_select_db("$database") or die("Unable to Connect to DB");
> $tc_query = "INSERT INTO $tablel VALUES(NULL, $lname, $fname, $machine_name,
> $email_addr, $problem, NULL)";
> $result = mysql_query($tc_query);
> mysql_close();
>
> So what exactly do I seem to be missing here?

A lot of single quotes... around the parameters you are inserting...

add in a print($tc_query) and see what that looks like... run that
directly in mysql and it will give you more details on the error.

Or, make it look like this:

$tc_query = "INSERT INTO $tablel VALUES(NULL, '$lname', '$fname',
'$machine_name', '$email_addr', '$problem', NULL)";

I'd also suggest you read this page:

http://www.php.net/mysql_escape_string

good luck!

-p

[Back to original message]