Parse Error

[Anon]

I am getting this error:

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /home/firstcty/firstcitymall-www/search_listings.php on line 22

When I run this search:

$sql = "SELECT * FROM $table_name WHERE keywords LIKE '%$search%';

$result = mysql_query($sql);

while ($row = mysql_fetch_array($result))

{

$keywords = $row['keywords'];
$category = $row['category'];
$bus_name = $row['bus_name'];...

'$keywords' is line 22 and '$search' is what the user put in the search box.

What am I missing here? I'm new at this so I suppose quite a bit...

Thanks

[vsego]

You're missing a double quote at the end of first line. :-)

[Anon]

Thanks!

Also now that it works it only recongnizes the first word if I put in more than one. Is there a way to make it see them all?

Here's the string again:

$sql = "SELECT * FROM $table_name WHERE keywords LIKE '%$search%'";

[[deleted]]

LIKE '%$string%'

will match on anything containing the entire contents of $string, not just parts of it.
If you want to match all the words you will have to put a seperate LIKE in the query for every word in $string.

Read the MySQL manual to see if the FULLTEXT search may be more appropriate for you.

[Anon]

Wouldn't replacing spaces with % also help?

$search = "this that";
$search = ereg_replace(" ","%",$search);

then do the query?

// Thomasson

[[deleted]]

Nice idea, but that would mean that the keywords still have to appear in the same order as they were given in.
So the keywords "hello world" would not match
"The world said hello"

[Anon]

vincent I trid the fulltext thing with this:

$sql = "SELECT * FROM $table_name WHERE MATCH (description,keywords) AGAINST ('$search')";

$result = mysql_query($sql);

while ($row = mysql_fetch_array($result))
{...

And I get this ERROR:

Warning: Supplied argument is not a valid MySQL result resource in /home/firstcty/firstcitymall-www/search_listings.php on line 18

while ($row... is line 18 what am I missing?

[mrjam]

aha, true...

does mysql support "... LIKE %this% OR LIKE %THAT% OR %OTHER%" ?

New to this, but find it interesting 😉

// Thomasson

[vsego]

I see no reason why not. But, it would have to be
(x LIKE '%this%') or (x LIKE '%that') or...

[[deleted]]

try printing mysql_error() directly after executing the query, I think you'll find that either fulltext is not available for your database, or you have not created a fulltext index.

[Anon]

Thanks vince I'm at least on the right track now...