In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Dear all,
> i need help with my search query statement.. what is wrong with my code?
> $word = split(" ", $keyword);
> $num_words = count($word);
> $word_str = "";
> $criteria = "";
> for ($i=0; $i<$num_words; $i++)
> if ($i)
> $word_str .= "and colName like '%".$word[$i]."%' ";
> $word_str .= "colName like '%".$word[$i]."%' ";
> $word_str .= "and col2 = '$foo' ";
> $criteria .= "$word_str ";
> $table .= "db_table";
> $query = "select * from ".$table." where ".$criteria;
> when i try to echo $query, i get --- select * from where
> and so of course MySQL gives me an error 1064 near ' where '
> what happened?
> thanx thanx!
For a guess - $keyword and $table are set in another form and you have
register_globals set to off. You need to use $_POST or $_GET depending on
how the info is submitted.
You should also consider the case where $keyword or $table is submitted as
an empty string.
Quod subigo farinam
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
Q: What is the most annoying thing on usenet?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php