What's wrong with this....?

[Dragoon]

Anyone give it a little look over and see if they can find anything... it's probably something simple.. but I can't spot it.

<?
 if (isset($_POST["action"])) { $action = $_POST["action"]; } else { $action = null; }
if ($action == "post") {
echo "Posting";
$postauth = $_POST["cauthor"];
$postmail = $_POST["cmail"];
$postlocation = $_POST["clocation"];
$postcost = $_POST["ccost"];
$postbody = $_POST["cbody"];
odbc_do($db,"INSERT INTO Classified (ClassAuthor,ClassMail,ClassLocation,ClassCost,ClassBody,ClassDate) VALUES ('$postauthor','$postmail','$postlocation','$postcost','$postbody','now()')");
echo "<meta http-equiv=refresh content='0;URL=test.php'>";
}
?>

<table>
<Form action="test.php?action=post" method="POST"><BR>
<tr><td>Author:</font></td><td><input type="text" Name="cauthor" Value="Author" Maxsize="100"></td></tr>
<tr><td>E-mail:</font></td><td><input type="text" Name="cmail" Value="mail" Maxsize="100"></td></tr>
<tr><td>Location:</font></td><td><input type="text" Name="clocation" Value="location" Maxsize="200"></td></tr>
<tr><td>Cost:</font></td><td><input type="text" Name="ccost" Value="00.00" Maxsize="10"></td></tr>
<tr><td>Body:</font></td><td><textarea width="100%" name="cbody" cols="50" rows=10></textarea></td></tr>
<tr><td><input type="submit" Value="Submit"></td>
</Form>
</table>

[barand]

What error message do you get?

What database are you connecting to via odbc?

If it's ms access, for instance, it likes dates wrapped in "#"

odbc_do($db,"INSERT INTO Classified  (ClassAuthor,ClassMail,ClassLocation,ClassCost,ClassBody,ClassDate) VALUES  ('$postauthor','$postmail','$postlocation','$postcost','$postbody',#now()#)");

[tomhath]

Either you are doing somethnigI've never seen before or you have mixed GET and POST together (or tried to anyway).

Can you pass values (like $action) in the URL with POST? I thought that was only used with GET.

[Dragoon]

Haha, I forgot about this thread.
I went and tried something out about a minute later and got it.

Yeah, you're right, I had POST and GET mixed up for that first line that checks the address bar for info.