What is this error?

[billy_111]

Hey,

I have the following code below where i pull out data from my database. It works perfectly and actually pulls out exactly what i want. But there is an error that i get even though the code works.

Code is here:-

          $sql_mem = "SELECT job_location FROM tbl_job_reviews WHERE member_id = .".$_SESSION['MEM_ID']."'"; 
          $result_mem = mysql_query($sql_mem); 
          $row_mem = mysql_fetch_array($result_mem);
          
          $sql = "SELECT * FROM tbl_job_reviews WHERE authorised = 1 AND job_location LIKE '%" .$row_mem[job_location]. "%' "; 
          $result = mysql_query($sql); 
          $numrows = mysql_num_rows($result);

              while($row=mysql_fetch_array($result))
              { 
                  //Pull out details here...
                         } 

this is the error:-

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /domains/judgethejob.com/http/vinny/search/index.php on line 230

[Mittineague]

Maybe it's dying at the end of the while?

[paul_wilkins]

Code is here:-

          $sql_mem = "SELECT job_location FROM tbl_job_reviews WHERE member_id = .".$_SESSION['MEM_ID']."'"; 
          $result_mem = mysql_query($sql_mem); 
          $row_mem = mysql_fetch_array($result_mem);
          
          $sql = "SELECT * FROM tbl_job_reviews WHERE authorised = 1 AND job_location LIKE '%" .$row_mem[job_location]. "%' "; 
          $result = mysql_query($sql); 
          $numrows = mysql_num_rows($result);

              while($row=mysql_fetch_array($result))
              { 
                  //Pull out details here...
                         } 

this is the error:-

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /domains/judgethejob.com/http/vinny/search/index.php on line 230

Where is line 230. Is it the

$row_mem = mysql_fetch_array($result_mem);

line or the

while($row=mysql_fetch_array($result))

line.

[billy_111]

To this line:-

$numrows = mysql_num_rows($result);

Can you see where the problem is?

[Mittineague]

The error message has mysql_fetch_array in it, not mysql_num_rows
Are you sure?

I guessing that if you're seeing results, then the first query is working as the second uses it's result in it.

If you try

              echo $numrows . '<br>';
             while($row=mysql_fetch_array($result))
              { 
                            echo $result . '<br>';
                  //Pull out details here...
                         } 

Do you see something like
resource
resource
resource
.......
null