mysql_query problem

[eduard77]

I ty to make a mysql_query that looks like this

<?php require_once("includes/connection.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php mysql_close($connection);?>
<?php 
   $menu_name = $_POST['menu_name'];
   $position = $_POST['position'];
   $visible  = $_POST['visible'];
   ?>
  <?php
      $query = "INSERT INTO subjects (
          menu_name, position, visible
		  ) VALUES (
		   '{menu_name}', {position}, {visible}
		   )";
   if(mysql_query($query, $connection)) {
	    header("Location: content.php");
		exit;
   } else {
	   echo "<p>Subject creation failed.</p>";
	   echo "<p>" . mysql_error() . "</p>";
   }
   ?>

but  returns me the following error

Warning: mysql_query(): 5 is not a valid MySQL-Link resource in C:\wamp\www\widget_corp\create_subject.php on line 15

 

Subject creation failed.

I am thinking for a long while what could be wrong but I cannot find a solution.

So if anyone knows what should I do i would be very greatfull.

[PFMaBiSmAd]

Line three of the code you posted is closing the mysql connection, so what do you expect when you try to use that connection to execute a query?

[ManiacDan]

$connection is obviously the number 5 rather than a mysql link resource.  like the poster above me said, you close the connection and then try to use it.

 

-Dan