MySQL-Link Error

[Lauram340]

I have got an error but i don't understand what it means
My error says
Quote

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Users\Laura\Desktop\UPDATE\UPDATE\Update\www\police\content\crud_single_table\confirm_insert.php on line 3

and my code is this

$sql = "SELECT COUNT(*) FROM Workshift WHERE NAME ='$a_name_variable'";
   $result3= mysql_query($sql, $db);
   $count= mysql_result($result3,0,"COUNT(*)");
   if ($count >= 2)
   {
      echo 'You are already working the max, 2 shifts.';
   }

I can see its the mysql_query and mysql_result but how do i overcome this error and why is it saying its there?

[NogDog]

It's telling you that $db is not a mysql connection link resource. Either your connection failed, it was closed earlier in your code, or $db is the wrong variable name for the result of your call to mysql_connect(). (Or possibly some other error I haven't though of at the moment.)