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:-
this is the error:-
$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);
//Pull out details here...
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