Need help fast! --SQL Statement in PHP not working

micah1086

I've got this code in the survey.php page. Included in this page is the database connection--that's not the problem. The previous page that enters the username and password is just standard HTML. Please look at this code and let me know what it should be to update the form fields--I'm going to have all the passwords and usernames already entered. PLEASE HELP!!! 😃

<?
include("conn.php")
?>
<html>
<head>
<title>Liberty Survey</title>
</head>
<body>
<?
if(mysql_query("SELECT FROM survey WHERE username='$username' AND password='$password' AND taken='1')){
print("Sorry, you have already taken this survey");
}
elseif(mysql_query("SELECT FROM survey WHERE username = '$username' AND password = '$password'")){
$result = mysql_query($sql);
$num = mysql_numrows($result);
if ($num = "0") {
print("<h1>You are not authorized to take this survey</h1>")
}
}
else{
?>
<form action="survey.php" method="POST">
<p><b>Question 1: <input type="text" maxlength="3" name="one">
<br>Question 2: <input type="text" name="two">
<br><input type="Submit" name="onto2">
<?
}
if(isset($onto2)):
$sql = "UPDATE survey SET one='$one', two='$two' WHERE username='$username', password='$password'";
mysql_query($sql);
echo 'Database query successful';
print("<h2>Thank you for taking this survey</h2>");
else:
endif;
?>
</body>
</html>

Weedpacket

Since you don't say anything about what is actually happening, I can only guess that Question One of the Newbie's FAQ applies. You might also want to look at the Debugging 101 thread to get advice on how to solve problems.

Kudose

You might even solve your own problem if you use a coding program...like Dreamweaver...that changes the font colors according to the language your scripting in.

Also, when you post code on the board, try to remember to use the [ PHP] and [/ PHP ] brackets. Without the spaces obviously.

micah1086

This code is supposed to take the username and password entered from the previous page, then check to see whether that user has already taken the survey, check whether they have a valid username and password, and if those pass, then the script will display the survey form which is just two form fields right now. Once the form is filled out and the submit button is hit, the SQL statement is to be executed to update the rows WHERE username=$username and password=$password with the values entered in the form. The script seems to be stuck on the SQL statement because everything else works fine but all of the SQL statements seem to be dead. PLEASE HELP!!!