[RESOLVED] Invalid Result Resource

[rsmith]

The below code gives me a mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource and doesn't print the table row to the screen:

$keywords = mysql_real_escape_string($_GET['kw']);
$kw = explode(" ", $keywords);

foreach($kw AS $keyword){
     $query = "SELECT id, title FROM Properties WHERE INSTR(description, $keyword) OR WHERE INSTR(area, $keyword) AND active = 'Yes'";
     $result = mysql_query($query);
     $info = mysql_fetch_assoc($result);

 echo "<tr>";
 echo "<td>".$info['id']."</td><td>".$info['title']."</td>";
 echo "</tr>";

I can't figure it out, what am I missing? probably something very basic.

TIA

[NogDog]

That usually means your preceding mysql_query() call returned false, due to MySQL not being able to parse/process the supplied query. You can get more debug info by checking for a result of false and getting the latest error message via [man]mysql_error/man.

The immediate problem I see in the query is that you have two occurrences of "WHERE", but you can only have one WHERE clause in a query.

[rsmith]

How would I have it check each of those columns then in the where clause? It needs to search for the current keyword in each of the columns, should I just use OR instead of OR WHERE?

[NogDog]

Yes, just separate each condition with AND or OR as appropriate, using parentheses to group conditions where needed. E.g., depending on the intended logic:

. . . WHERE (INSTR(description, $keyword) OR INSTR(area, $keyword)) AND active = 'Yes'
---or---
. . . WHERE INSTR(description, $keyword) OR (INSTR(area, $keyword) AND active = 'Yes')

[rsmith]

Thanks. I've done that but it doesn't seem to be searching properly. Some keywords work, others don't. Even if I copy and paste from the column into the search it'll still come up with 0 results.

[rsmith]

moved to new thread

[rsmith]

Anyone? Please and thank you!