error: Query was empty can someone help please

[k994519]

Hi guys

I have created a form which check if there has been 8 check boxes clicked, and if they have then it is supposed to passed the value of the tickbox to the database with the insert function as below, returns an error saying the query is empty

please help

code below

<?php  

session_start(); 
header("Cache-control: private"); 

//$page_title = "Survey Admin: Edit Questions"; 
include_once("start_page_login.php"); 
print("<h3>Welcome to the admin page <b>".$_SESSION["login"]."</h3></b><br>\n"); 
include_once("start_page_admin.php"); 
include_once("config.php"); 
include_once("forms.php"); 

doCSS(); 
//print_r($_POST);
if(isset($_POST["submit"]))
{
	echo "PASSED";
	if (count($_POST["hus"]) != 8 )
	{
		echo "ensure u have selected 8 options!<br>";
	}
	else
	{
		for ($i = 0; $i < 8; $i++)
		{
			echo "the first option 2 insert is " . ($_POST["hus"][$i]) . "</br>";
			$Query ="insert into students (module_id, module_id2, module_id3, module_id4, module_id5, module_id6, module_id7, module_id8) VALUES 'hus[$0]', 'hus[$1]', 'hus[$2]', 'hus[$3]', 'hus[$4]', 'hus[$5]', 'hus[$6]', 'hus[$7]')";
			$result=mysql_query($query, $link) or die("Died inserting new student info into db.  Error returned if any: ".mysql_error());
		}
	}

}

?>
<form action="<?=$_SERVER["PHP_SELF"]?>" method="POST">

<?php


$query=("select module_id, description from modules order by module_id");
// Run query:
$result=mysql_query($query, $link) or die("MySQL query $query failed.  Error if any: ".mysql_error());

while($row = mysql_fetch_row($result)) 
{ 
	echo "<input type=checkbox name=hus[] value=" . $row[0] . ">" . $row[1] . "<br>";
}

?>



<input name="submit" type="submit" value="Submit">&nbsp;<input type="reset" name="Reset" value="Reset">
</form>

thanks as ever!!!

[swr]

You set your query into a variable called $Query, but then do mysql_query($query, $link).

$Query and $query are different variables.

If you would use error_reporting(E_ALL) it would've given you a notice about an undefined variable.

[k994519]

HI

Ive made the changes but all that happens now is that query puts a 0 instead of the value of row 0 from the db.......
i have also I have made sure there are no syntax errors.....

help

[swr]

Well, this really doesn't look right:

$Query ="insert into students (module_id, module_id2, module_id3, module_id4, module_id5, module_id6, module_id7, module_id8)
VALUES 'hus[$0]', 'hus[$1]', 'hus[$2]', 'hus[$3]', 'hus[$4]', 'hus[$5]', 'hus[$6]', 'hus[$7]')";

That should probably be $hus[0] and so on, not hus[$0].

Again, error_reporting(E_ALL) would've given you a notice about this if it had been set.