$_POST INSERT Difficulties

pterodactyl

I am a newbie to PHP and MYSQL.

I am trying to learn the principle of getting data from a form into a database.

I have tried for days now wit many diffferent approaches. Gosh I am beginning to hate punctuation again.

Here are snippets of what I have from my form and the php program in the action.

Thanks

I have an include file that does my login

<?php
include "dbvisit.inc";

$email = $POST["email"];
$task = $POST["task];
$link = mysql_connect ("$hostName", "$userName", "$passWord");
mysql_select_db ("visitors");
mysql_query = INSERT INTO visitors ( email , task ) VALUES (
'$email', '$task' );
?>

<FORM ACTION="http://www.pterodactylcoffee.com/php/visitorInput.php"
method ="POST">
<input type="text" name="email" size="30">
<select name="task" size="2">
<option value="Subscribe" selected>Subscribe</option>
<option value="Unsubscribe">Unsubscribe</option>
</select>
<input type="submit" name="Submit" value="action">
</FORM>

Thanks

Harry

🙂

devinemke

this is wrong:

mysql_query = INSERT INTO visitors (email, task) VALUES ('$email', '$task');

change to:

$result = mysql_query("INSERT INTO visitors (email, task) VALUES ('$email', '$task')");
if ($result) {echo 'db insert OK';} else {echo 'db insert FAIL';}