yakoup46

Thank you very much the code works like a charm!

I did as you had suggested an still got the query was empty error! ARRRGHHH!!! LOL function checkAnswer($button, $inputbox, $session, $table, $column, $answer) { if(isset($_POST[$button]) || $_POST[$inputbox]) { $sql="INSERT INTO $table ($column) VALUES ('$_POST[$inputbox]')"; if($_POST[$inputbox] != $answer) { echo "Sorry Wrong!"; session_start(); if(isset($_SESSION[$session])) { $_SESSION[$session] = $_SESSION[$session] + 1; // Could use $_SESSION[$session]++; } else { $_SESSION[$session] = 1; } } else { echo "Correct!"; } echo "<br />Number of incorrect answers = ". $_SESSION[$session]; } } checkAnswer("buttonsumofodds", "inputbox1", "views1", "Sumofodds", "ValueOdds", "280"); checkAnswer("buttonsumofchain", "inputbox3", "views3", "Sumofchain", "ValueChain", "820"); checkAnswer("buttonsumofsquares", "inputbox2", "views2", "Sumofsquares", "ValueSquares", "2870"); checkAnswer("buttonsumofprimes", "inputbox5", "views5", "Sumofprimes", "ValuePrimes", "1060"); checkAnswer("buttonsumofdifference", "inputbox4", "views4", "Diffofsums", "ValueDiff", "-144"); echo "<br /><a href='http://luta.comuv.com/Easy/easy.html'>Go Back</a>"; if(!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } mysql_close($con); ?>

I fixed the row thing... but doesnt the bold stuff tell it what table to put it into? checkAnswer("buttonsumofodds", "inputbox1", "views1", "Sumofodds", "280"); checkAnswer("buttonsumofchain", "inputbox3", "views3", "Sumofchain", "820"); checkAnswer("buttonsumofsquares", "inputbox2", "views2", "Sumofsquares", "2870"); checkAnswer("buttonsumofprimes", "inputbox5", "views5", "Sumofprimes", "1060"); checkAnswer("buttonsumofdifference", "inputbox4", "views4", "Diffofsums", "-144");

What do you mean?

I am not really sure what is going on, but for some reason I am getting a "Query is Empty" error. This code was suggested to me in another post so I am not completly farmilar with it. I have looked it over but cannot find why I would be getting the error. function checkAnswer($button, $inputbox, $session, $table, $answer) { if(isset($_POST[$button]) || $_POST[$inputbox]) { $sql="INSERT INTO $table VALUES ('$_POST[$inputbox]')"; if($_POST[$inputbox] != $answer) { echo "Sorry Wrong!"; session_start(); if(isset($_SESSION[$session])) { $_SESSION[$session] = $_SESSION[$session] + 1; // Could use $_SESSION[$session]++; } else { $_SESSION[$session] = 1; } } else { echo "Correct!"; } echo "<br />Number of incorrect answers = ". $_SESSION[$session]; } } checkAnswer("buttonsumofodds", "inputbox1", "views1", "Sumofodds", "280"); checkAnswer("buttonsumofchain", "inputbox3", "views3", "Sumofchain", "820"); checkAnswer("buttonsumofsquares", "inputbox2", "views2", "Sumofsquares", "2870"); checkAnswer("buttonsumofprimes", "inputbox5", "views5", "Sumofprimes", "1060"); checkAnswer("buttonsumofdifference", "inputbox4", "views4", "Diffofsums", "-144"); echo "<br /><a href='http://luta.comuv.com/Easy/easy.html'>Go Back</a>"; if(!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } mysql_close($con); ?>

I used your code and now I am getting a "Query is Empty" error? function checkAnswer($button, $inputbox, $session, $table, $answer) { if(isset($_POST[$button]) || $_POST[$inputbox]) { $sql="INSERT INTO $table VALUES ('$_POST[$inputbox]')"; if($_POST[$inputbox] != $answer) { echo "Sorry Wrong!"; session_start(); if(isset($_SESSION[$session])) { $_SESSION[$session] = $_SESSION[$session] + 1; // Could use $_SESSION[$session]++; } else { $_SESSION[$session] = 1; } } else { echo "Correct!"; } echo "<br />Number of incorrect answers = ". $_SESSION[$session]; } } checkAnswer("buttonsumofodds", "inputbox1", "views1", "Sumofodds", "280"); checkAnswer("buttonsumofchain", "inputbox3", "views3", "Sumofchain", "820"); checkAnswer("buttonsumofsquares", "inputbox2", "views2", "Sumofsquares", "2870"); checkAnswer("buttonsumofprimes", "inputbox5", "views5", "Sumofprimes", "1060"); checkAnswer("buttonsumofdifference", "inputbox4", "views4", "Diffofsums", "-144"); echo "<br /><a href='http://luta.comuv.com/Easy/easy.html'>Go Back</a>"; if(!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } mysql_close($con); ?>

Wow thank you so much! That is about 95% less code.

O crap, I meant to ask if there is anyway to shorten it up? LOL

Sharing what?

Can someone that has Internet Explorer try this out, cuz my buddy said he is getting a Query is Empty in I.E. (but i am not) Go to http://www.luta.comuv.com Click on easy and try on of the problems, just enter any number it doesn't matter, and see if you get Query is Empty

<title>The Java Project</title> <?php if(isset($_POST['buttonsumofodds']) || $_POST['inputbox1']) { $sql="INSERT INTO Sumofodds (ValueOdds) VALUES ('$_POST[inputbox1]')"; if($_POST[inputbox1] != 280) { echo "Sorry Wrong!"; session_start(); if(isset($_SESSION['views1'])) { $_SESSION['views1'] = $_SESSION['views1']+ 1; } else { $_SESSION['views1'] = 1; } } else { echo "Correct!"; } echo "<br>Number of incorrect answers = ". $_SESSION['views1']; } if(isset($_POST['buttonsumofchain']) || $_POST['inputbox3']) { $sql="INSERT INTO Sumofchain (ValueChain) VALUES ('$_POST[inputbox3]')"; if($_POST[inputbox3] != 820) { echo "Sorry Wrong!"; session_start(); if(isset($_SESSION['views3'])) { $_SESSION['views3'] = $_SESSION['views3']+ 1; } else { $_SESSION['views3'] = 1; } } else { echo "Correct!"; } echo "<br>Number of incorrect answers = ". $_SESSION['views3']; } if(isset($_POST['buttonsumofsquares']) || $_POST['inputbox2']) { $sql="INSERT INTO Sumofsquares (ValueSquares) VALUES ('$_POST[inputbox2]')"; if($_POST[inputbox2] != 2870) { echo "Sorry Wrong!"; session_start(); if(isset($_SESSION['views2'])) { $_SESSION['views2'] = $_SESSION['views2']+ 1; } else { $_SESSION['views2'] = 1; } } else { echo "Correct!"; } echo "<br>Number of incorrect answers = ". $_SESSION['views2']; } if(isset($_POST['buttonsumofprimes']) || $_POST['inputbox5']) { $sql="INSERT INTO Sumofprimes (ValuePrimes) VALUES ('$_POST[inputbox5]')"; if($_POST[inputbox5] != 1060) { echo "Sorry Wrong!"; session_start(); if(isset($_SESSION['views5'])) { $_SESSION['views5'] = $_SESSION['views5']+ 1; } else { $_SESSION['views5'] = 1; } } else { echo "Correct!"; } echo "<br>Number of incorrect answers = ". $_SESSION['views5']; } if(isset($_POST['buttonsumofdifference']) || $_POST['inputbox4']) { $sql="INSERT INTO Diffofsums VALUES ('$_POST[inputbox4]')"; if($_POST[inputbox4] != -144) { echo "Sorry Wrong!"; session_start(); if(isset($_SESSION['views4'])) { $_SESSION['views4'] = $_SESSION['views4']+ 1; } else { $_SESSION['views4'] = 1; } } else { echo "Correct!"; } echo "<br>Number of incorrect answers = ". $_SESSION['views4']; } echo "<br><a href='http://luta.comuv.com/Easy/easy.html'>Go Back</a>"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } mysql_close($con) ?>

OMG!!! Duh I am an idiot! Thanks.

I am trying to keep track of the number of wrong guess' that someone has submitted. I am not really sure what to do, I want to avoid database entries, b/c the data is only purposeful per visit. So... $box1 = 0; if(isset($_POST['buttonsumofodds']) || $_POST['inputbox1']) { $sql="INSERT INTO Sumofodds (ValueOdds) VALUES ('$_POST[inputbox1]')"; if($_POST[inputbox1] != 280) { echo "Sorry Wrong!"; $box1++; echo $box1; } else { echo "Correct!"; } } Obviously this code is just code to print "Sorry Wrong 1" and when they go back it try again and fail it will print "Sorry Wrong 1". So, I was wondering if there was someway to track the IP address, or something, so the server noes to increase $box1 per IP address.

Thanx for all the help!

Okay so how do I display this text near the input box?