Image

Imagetsuyogari wrote in Imagephp

problem with form

I'm trying to have a form send a point value of 100-500 to the MySQL database, but for some reason, any value over 100 is being sent as 127, no matter what point value. Any ideas??



<?


include('config.php');

$conn = mysql_connect($host, $user, $pass)

or die("Unable to connect to MySQL");


mysql_select_db($db);


$stid = $HTTP_COOKIE_VARS["edsgame"];


if (isset($_POST['submit'])) {


// if empty, go back and fill everything in


if(empty($_POST['answer'])) {

echo "No answer??";

}


else {


$cat = $_POST['cid'];

$pnt = $_POST['pnt'];

$ans = addslashes($_POST['answer']);


// insert info into database


$query = "INSERT INTO answers (studentid, catid, points, answer) VALUES ('$stid', '$cat', '$pnt', '$ans')";

mysql_query($query) or die('Error, insert failed.');


?>


Answer has been saved! You can click the link below to close the window.

<br /><br />

<a href="javascript:window.close();">CLOSE WINDOW</a>


<?


} }


else {


?>


<html>

<head>

<title>Write Your Answer</title>

</head>


<body bgcolor="#FFFFFF">


<h4>Please choose the correct category/point value and submit your answer.</h4><br>

<br /><br /><br />

<form method="post" action="answer.php">

Category:

<select name="cid" id="cid">

<option value="1">Becoming A Teacher</option>

<option value="2">Educational History</option>

<option value="3">Educational Law</option>

<option value="4">Educational Belief Systems</option>

<option value="5">First Amendment</option>

<option value="6">Special Interest/Scholarship</option>

</select>

<br>

Point Value:

<select name="pnt" id="pnt">

<option value="100">100</option>

<option value="200">200</option>

<option value="300">300</option>

<option value="400">400</option>

<option value="500">500</option>

</select>

<br>

<br>

<textarea cols="50" rows="10" id="answer" name="answer"></textarea>

<br />

<br />

<input name="submit" type="submit" id="submit" value="Submit" />

</form>


</body>

</html>


<? }


mysql_close($conn);

?>



LJ Video