WHERE/OR

[brisk]

Hey guys

In the tutorial there is (using my column/table names):

[syntax=php]FROM threads
WHERE {$fact_where}
OR {$quote_where}
[/syntax]

But I have about 8+ columns, so how do I do the OR bit? I tried WHERE, OR, OR, OR but it doesn't work so what is the correct syntax?

Thanks

Ed

[jacek]

You should be able to OR, OR, OR, OR, OR ye[

try adding

[syntax=php]echo mysql_error();[/syntax]
after the failed query and see if it tells you what is wrong.

[brisk]

You should be able to OR, OR, OR, OR, OR ye[

try adding

[syntax=php]echo mysql_error();[/syntax]
after the failed query and see if it tells you what is wrong.

I'm getting the "Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given" error. I can assure you each column has the word 'green' in it which is the word I'm searching with.

[syntax=php]function search_posts($term){

//same as explode instead of character, will take regular expression
$keywords = preg_split('#\s+#',mysql_real_escape_string($term));

if (empty($keywords)){
return array();
}

$headline_where = "`headline` LIKE '%" . implode("%' OR `headline` LIKE '%", $keywords) . "%'";
$fact_where = "`fact` LIKE '%" . implode("%' OR `fact` LIKE '%", $keywords) . "%'";
$idea_where = "`idea` LIKE '%" . implode("%' OR `idea LIKE '%", $keywords) . "%'";
$quote_where = "`quote` LIKE '%" . implode("%' OR `quote` LIKE '%", $keywords) . "%'";

$sql = "SELECT

`headline`
`fact`
`idea`
`quote`


FROM threads
WHERE {$headline_where}
OR {$fact_where}
OR {$idea_where}
OR {$quote_where}


";
$result = mysql_query($sql);

$results = array();

while (($row = mysql_fetch_assoc($result)) !== false){
$results[] = $row;
}

return $results;
}


?>[/syntax]

[syntax=php]<?php

if (empty($_GET['term']) === false){
print_r(search_posts($_GET['term']));

echo count($search_results);

if (empty($search_results)){
echo 'Your search returned no results';
}

foreach ($search_results as $results){
echo "<h3>{results['headline']}</h3>";
echo "<h3>{results['fact']}</h3>";
echo "<h3>{results['idea']}</h3>";
echo "<h3>{results['quote']}</h3>";
}
}


?> [/syntax]

[jacek]

[syntax=php]implode("%' OR `idea LIKE '%", $keywords)[/syntax]
You missed a ` after idea.

Hard to spot !

[brisk]

[syntax=php]implode("%' OR `idea LIKE '%", $keywords)[/syntax]
You missed a ` after idea.

Hard to spot !

Wow nice one, sorry for that.

It's still not working Getting same error.

Screen shot of my table:

http://img15.imageshack.us/img15/1024/13286720.png

[Temor]

add [syntax=php]echo mysql_error();[/syntax] after running your query, but before the return line.

[jacek]

In what way is it not working ?

[brisk]

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\budgie\Organised2\functions\functions.php on line 486
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`idea` `quote` FROM threads WHERE `headline` LIK' at line 5

I missed out the commas for each column after 'SELECT' statement, I put them in but it's still not working proper, it's returning results though. Let me have a go first.

[brisk]

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\budgie\Organised2\functions\functions.php on line 486
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`idea` `quote` FROM threads WHERE `headline` LIK' at line 5

I missed out the commas for each column after 'SELECT' statement, I put them in but it's still not working proper, it's returning results though. Let me have a go first.

All solved

Cheers guys.