[Resolved] stupid warnings! frustration!

phence

sorry to bother with these warnings, but im getting frusterated.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/test/search2.php on line 83

$sql = mysql_query("SELECT * FROM table WHERE MATCH (item) AGAINST ('$searchValue') LIMIT $from, $max_results"); 
while($row = mysql_fetch_array($sql)){

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/www/test/search2.php on line 128

// Figure out the total number of results in DB: 
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM table WHERE MATCH (item) AGAINST ('$searchValue')"),0);

this is how i get the value of $searchValue:

	// Collect Seach Value & Turn into Session
	session_start();

if (!empty($_GET["searchValue"]))
	$searchValue = trim($_GET["searchValue"], 25);
elseif (!empty($_POST["searchValue"]))
	$searchValue = trim($_POST["searchValue"], 25);
else
{ 
	session_is_registered("sessionSearchValue");
	$searchValue = $_SESSION["sessionSearchValue"];
}

these warnings are shown when i try to run my script...
no results are shown!

I don't understand why i am getting these warnings... I have an almost identical script, that searches the same query, except there is not user input, and that script runs fine.

it seems when i add the user input, everything goes wrong!! why?

stolzyboy

change this

$sql = mysql_query("SELECT * FROM table WHERE MATCH (item) AGAINST ('$searchValue') LIMIT $from, $max_results");

to this

$sql = mysql_query("SELECT * FROM table WHERE MATCH (item) AGAINST ('$searchValue') LIMIT $from, $max_results") or die(mysql_error());

and this

$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM table WHERE MATCH (item) AGAINST ('$searchValue')"),0);

to this

$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM table WHERE MATCH (item) AGAINST ('$searchValue')"),0) or die(mysql_error());

this will aid in your troubleshooting, the reason you get those errors is because the query is working correctly, if it is empty, if you haven't connected to mysql or the db correctly, etc....

phence

hey thanks!!

now i am getting this error..
You have an error in your SQL syntax near 'table WHERE MATCH (item) AGAINST ('\'test\'') LIMIT 0, 20' at line 1

whats wrong with my query string?

stolzyboy

before your $sql do this

$searchValue = stripslashes(searchValue);

phence

Thanks agian for helping out...

but still no luck!

You have an error in your SQL syntax near 'table WHERE MATCH (item) AGAINST (''test'') LIMIT 0, 20' at line 1

stolzyboy

do this before $sql, but after your other stuff i gave you

$searchValue = str_replace("'", "", $searchValue);

phence

not having any luck with this one..

You have an error in your SQL syntax near 'table WHERE MATCH (item) AGAINST ('test') LIMIT 0, 20' at line 1

thanks for sticking with me

stolzyboy

your actual table isn't called table is it?

i ask cuz it is a mysql reserved word

http://www.mysql.com/doc/en/Reserved_words.html

phence

nope, the actual name is not table

r270ba

Then if your table name is not called table you don't want to SELECT FROM table. . .you want to SELECT FROM table_name. . .

Say the table name is test. . .your query would be. . .

$sql = mysql_query("SELECT * FROM test WHERE MATCH (item) AGAINST ('$searchValue') LIMIT $from, $max_results") or die(mysql_error());

phence

yes, i know this!

simply used 'table' in the query in the post to lessen confustion, i now see that it has cause more confusion..

anyone have a solution

phence

sorry guys! i'm a moron, i forgot to FULLTEXT index my item column of my mysql table!!!

thanks for the help!!!