<div>
The query is surrounnded by double quotes, and then you also have double quotes in the query itself. 
</div>


The query is surrounnded by double quotes, and then you also have double quotes in the query itself.

<div>
escape the quotes with a \ ... &nbsp;check this out:<br />
<br />
<a href="http://php.net/manual/en/language.types.string.php" rel="ugc">http://php.net/manual/en/language.types.string.php</a><br />

</div>


escape the quotes with a \ ...  check this out:

http://php.net/manual/en/language.types.string.php [http://php.net/manual/en/language.types.string.php]


<div>
Thanks a lot Frosty you rock!!!<br />
<br />
(by the way, it was just a stupid error on my part.... guest_courses was not a field in the database -- I'm in panic mode here as we did an upgrade and working through PHP errors everywhere!!)<br />
<br />
Cheers!
</div>


Thanks a lot Frosty you rock!!!

(by the way, it was just a stupid error on my part.... guest_courses was not a field in the database -- I'm in panic mode here as we did an upgrade and working through PHP errors everywhere!!)

Cheers!

<div>
I can't count the number of times this has happened to me. Dying properly on error, and printing out your SQL statements always makes the debugging process much easier. Glad to help :)<br />

</div>


I can't count the number of times this has happened to me. Dying properly on error, and printing out your SQL statements always makes the debugging process much easier. Glad to help :)


<div>
<div class="content wysiwyg-content">
$ins_result = mysql_query(&quot;SELECT * FROM users WHERE guest_faculty!='1' AND (faculty_courses LIKE '%,&quot;.$currUserCourse.&quot;,%' OR instructor_courses LIKE '%,&quot;.$currUserCourse.&quot;,%')<wbr /> ORDER by instructor_courses DESC&quot;);<br />
<br />
while ($row = mysql_fetch_array($ins_res<wbr />ult)) {<br />
&nbsp; $row['ID'];<br />
}<br />
<br />
<br />
I'm getting this error:<br />
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/vhosts/******/***<wbr />***/*****/<wbr />httpdocs/s<wbr />idebar_ins<wbr />tructor.ph<wbr />p on line 18<br />
<br />
Line 18 is the &quot;while()&quot; line.<br />
<br />
Thanks!<br />

</div>
</div>


$ins_result = mysql_query("SELECT * FROM users WHERE guest_faculty!='1' AND (faculty_courses LIKE '%,".$currUserCourse.",%' OR instructor_courses LIKE '%,".$currUserCourse.",%') ORDER by instructor_courses DESC");

while ($row = mysql_fetch_array($ins_result)) {
  $row['ID'];
}


I'm getting this error:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/vhosts/******/******/*****/httpdocs/sidebar_instructor.php on line 18

Line 18 is the "while()" line.

Thanks!


Whats' wrong with this query?

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.