So this is confusin the hell out of me.
I have a form that submits to a php file.
I can see the correct values for the data in the URL if I use method="GET" but the script doesn't see them.
form.html
<html>
<head>
<title>input form</title>
<body>
<br><br><br><br>
<form action="do_addres.php" method="get">
<select name="TitleID">
<option value="1">Title A</option>
<option value="2">Title B</option>
<option value="3">Title C</option>
</select>
<select name="CatID">
<option value="1">AA</option>
<option value="2">BB</option>
<option value="3">CC</option>
</select>
<input type="hidden" name=test value="14">
<input type="submit" name="submit" value="FINISHED">
</form>
</body>
</html>
do_addres.php
<?
// test project
// takes values from form.html and inserts them into storycatRes
$connection = mysql_connect("localhost", "user", "password") or die ("Couldn't connect! 1");
$table_name = "storycatRes";
$sql = "INSERT INTO $table_name (titleID, catID) VALUES (\"$TitleID\", \"$CatID\")";
echo "$TitleID";
echo $CatID;
echo $sql;
echo $test;
echo "<br><br><br><br><a href=\"addform.html\">again</a>";
//$result = mysql_query($sql, $connection) or die ("couldn't execute query 2");
?>
non of the values from form.html are being echoed anywhere.
also...
these files are in /home/user/public_html
and in /home/user/public_html/phpmyadmin
is phpmyadmin and it works fine.
I though it might be a permissions thing so I changed both files to the same permissions/ownership as the phpmyadmin files but no luck.
I don't understand what is going on.
