why wont this display multipul results?

phence

I am trying to get this query to display multipul results. if there is only one match in the mysql database it will display the result with no problem, but if there is more than one match then, there is an error and the database will not return any results.

what am i doing wrong?

MY CODE

// Build a query:
$query = "SELECT * FROM listings WHERE MATCH trading AGAINST ('$searchValue')";

// Run the query. 
$result = mysql_query($query);

if(!$result) {
    echo "Query $query failed.";

// If the query failed, reason why:
    echo mysql_error();
} else {

// test the number of rows in the result set:
if(!mysql_num_rows($result)) {
        echo "Query $query returned no results.";
} else {
        while($data = mysql_fetch_array($result)) {
        // process the data array for each row in the result set
                // Get vars
                $trading = $data["trading"];
                $for_ = $data["for_"];
                $wac_1 = $data["wac_1"];
                $wac_2 = $data["wac_2"];
	$enter_time = $data["enter_time"];
	$overdue_time = $data["overdue_time"];
	$user_id = $row["user_id"];

// find time left		
// Get the number of seconds:
$seconds =  $overdue_time - time();
// the number of whole days is the number of seconds / 86400:
$days = (int)($seconds / (60 * 60 * 24));
// get any remainder:
$r = (int)($seconds % (60 * 60 * 24));
if($r) {
    	// the number of hours is the remainder divided by 3600:
    	$hours = (int)($r / (60 * 60));
    	$r = (int)($r % (60 * 60));
 	if($r) {
            $minutes = (int)($r / 60);
            $secs = (int)($r % 60);
    	}
}
$time_left = date(d, $days) . " days " . date(h, $hours) . " hours " . date(i, $minutes) . " mins " . date(s, $secs) . " secs";

// make over_duetime a user format

// Line contents for each listing
$line1 = "<br><br>$user_id : Wants To Trade $trading For $for_<br>";

// if wac's have no value then display line 
if (!(empty($wac_1)) && (!(empty($wac_2)))){
	$line2 = "Will also Consider Trading for: $wac_1; $wac_2;<br>";
}	
elseif (empty($wac_1) && empty($wac_2)){
	$line2 = "$user_id, is not willing to trade for anything else";
}

$line3 = "<a href=\"listing.php\">View Complete Listing</a> Listing ends in $time_left on " . date('m/d/Y', $overdue_time);

// start a <table>, print one listing; Organize results to fit page & display results
echo $header;
echo $ads;
			echo "\n<table>\n<tr>" . "\n<tr>" . "\n\t<td>" . $line1 . " </td> 
		 	     \n<tr>" . "\n<tr>" . "\n\t<td>" . $line2 . " </td>
		 	     \n<tr>" . "\n<tr>" . "\n\t<td>" . $line3 . " </td>";
			echo $footer;
   	}
   }
}

----------------------------------------------------------------------------------

Please help, thank-you

Weedpacket

What's the error?

phence

this is the error:

Query SELECT * FROM listings WHERE MATCH trading AGAINST ('') returned no results.

Also i have just noticed, no mater the '$searchValue' as long as there is only one item in the database it displays that result, no matter if it matched the search value or not.

And if there is more than one lising in the database, no matter the content, it displays the error msg above also.

what do u think?

Weedpacket

Well judging from the error message it looks like $searchValue is empty. I take it it's coming from a form? Then you're probably better off using $GET['searchValue'] or $POST['searchValue'] (whichever method your form used). And maybe also check that your form field really is named "searchValue".

phence

this is the code i used to get: $searchValue

// get user search input
$seachValue = $HTTP_POST_VARS["searchValue"];
trim($seachValue);

Weedpacket

Okay....

Now does $HTTP_POST_VARS['searchValue'] contain what it should at this point?

You're not putting the string returned by the trim() function anywhere, so that line's doing nothing right now...

Andy_B2

If that's a cut and paste from your code, you've spelt searchValue wrong - it's missing an 'r'.

phence

HERE's the whole script... when there are more than one record in the mysql database,
i get this message:
Query SELECT * FROM listings WHERE MATCH trading AGAINST ('') returned no results.
If there is only one record in the database, not matter the $searchValue, it allways shows that one listing.

<?php
// singleSearch.php: Search for_ column, and compare to user input, display results.

include 'error.inc';
include 'db.inc';
//----------------------------------------------------------------------------------------
//connect to the database

if(!($connection = @ mysql_pconnect($hostname, $username, $password)))
	die("Could Not Connect to database");
if (!mysql_select_db($databaseName, $connection))
	showerror();

//-----------------------------------------------------------------------------------------

// get user search input
$searchValue = $HTTP_POST_VARS["searchValue"];
	trim($searchValue);


// Build a query:
$query = "SELECT * FROM listings WHERE MATCH trading AGAINST ('$searchValue')";

// Run the query. If the query fails, it won't return a result set identifier:
$result = mysql_query($query);

if(!$result) {
	echo "Query $query failed.";

	// If the query failed, MySQL is usually friendly enough to offer a reason why:
	echo mysql_error();
} else {
	// Just because a query executed succussfully doesn't necessarily mean there are rows in the result set.
	// So test the number of rows in the result set:
	if(!mysql_num_rows($result)) {
    	echo "Query $query returned no results.";
	} else {
    	while($data = mysql_fetch_array($result)) {
        	// process the data array for each row in the result set here...
			// Get vars
			$trading = $data["trading"];
			$for_ = $data["for_"];
			$wac_1 = $data["wac_1"];
			$wac_2 = $data["wac_2"];
			$enter_time = $data["enter_time"];
			$overdue_time = $data["overdue_time"];
			$user_id = $row["user_id"];

			// find time left		
			// Get the number of seconds:
			$seconds =  $overdue_time - time();
			// the number of whole days is the number of seconds / 86400:
			$days = (int)($seconds / (60 * 60 * 24));
			// get any remainder:
			$r = (int)($seconds % (60 * 60 * 24));
			if($r) {
    				// the number of hours is the remainder divided by 3600:
    				$hours = (int)($r / (60 * 60));
    				$r = (int)($r % (60 * 60));
 				      if($r) {
            				$minutes = (int)($r / 60);
            				$secs = (int)($r % 60);
    				}
			}
			$time_left = date(d, $days) . " days " . date(h, $hours) . " hours " . date(i, $minutes) . " mins " . date(s, $secs) . " secs";

			// make over_duetime a user format

			// Line contents for each listing
			$line1 = "<br><br>$user_id : Wants To Trade $trading For $for_<br>";

			// if wac's have no value then display line 
			if (!(empty($wac_1)) && (!(empty($wac_2)))){
				$line2 = "Will also Consider Trading for: $wac_1; $wac_2;<br>";
			}	
			elseif (empty($wac_1) && empty($wac_2)){
				$line2 = "$user_id, is not willing to trade for anything else";
			}

			$line3 = "<a href=\"listing.php\">View Complete Listing</a> Listing ends in $time_left on " . date('m/d/Y', $overdue_time);

			// start a <table>, print one listing; Organize results to fit page & display results
			echo $header;
			echo $ads;
			echo "\n<table>\n<tr>" . "\n<tr>" . "\n\t<td>" . $line1 . " </td> 
		 	     \n<tr>" . "\n<tr>" . "\n\t<td>" . $line2 . " </td>
		 	     \n<tr>" . "\n<tr>" . "\n\t<td>" . $line3 . " </td>";
			echo $footer;
   		 }
	 }
}

//end while loop	

?>

Thank-you all for your time, hopefully you can figure this out.

phence

also, the Http Vars name from the form is correct the copy/paste of the form is below

<form name="search" method="post" action="singleSearch.php">
Search:
<input type="text" name="$searchValue">
<input type="submit" name="Submit" value="Submit">
</form>

phence

also tried this:

<form name="search" method="post" action="singleSearch.php">
Search:
<input type="text" name="searchValue" >
<input type="submit" name="Submit" value="Submit">
</form>

...😕

Weedpacket

It looks pretty much okay to me (yes name='searchValue' is the correct method).

I note the trim line should be

$searchValue = trim($searchValue);

because trim returns its result instead of modifying the original value. But since that would mean
trim($searchValue); as you have it doesn't have any effect at all, that can't be the problem

I'm guessing the "return one result/return no results" difference is more due to MySQL's MATCH ... AGAINST operators.

Welcome to the wonderful world of debugging. Having fun yet? 🙂

I have one or two suspicions that this is starting to look like a configuration problem.

Alter the script to read as follows:

// get user search input
$searchValue = $HTTP_POST_VARS["searchValue"];
$searchValue = trim($searchValue); 

print $HTTP_POST_VARS['searchValue'].'<br>';
print $searchValue.'<br>';

We'll see if our searchValue is getting that far.

If everything was working, the searchValue should be printed twice, once trimmed. But in this case that shouldn't happen - because there's no chance for any more bugs between there and the $query= line.

If you do get searchValue printed twice, something is Very Wrong Indeed. My guess would be that neither get printed and something is preventing $HTTP_POST_VARS from being filled in.

So add the following line to the above snippet:

print_r($HTTP_POST_VARS);

and see exactly what it contains. If it's empty (there are supposed to be two elements, 'searchValue' and 'Submit') then something about your configuration is off. In that case, what version of PHP are you running, and what OS/Server combination (the last because rumour has it Microsoft PWS is buggy about POSTed forms)? If you're using a version of PHP >= 4.1, then $_POST[] would probably be a more appropriate choice than $HTTP_POST_VARS[], though I don't offer any claim that it would fix anything.

phence

okay, sounds like bad news...
heres what i got.

here is what was printed:
test
test
Array ( [searchValue] => test )

Heres my server info:
PHP Version 4.2.1
Red Hat Linux

http://www.tacit-design.com/phpinfo.php

Weedpacket

I'm sorry to say I can't see what gives then, (oh, did you try $_POST[]? Like I say, I doubt it would work, but it can't hurt...)

First of all, the Array should have had an entry

[Submit] => Submit

And second, there's no reason for $searchValue to lose its value between

// get user search input
$searchValue = $HTTP_POST_VARS["searchValue"];
trim($searchValue);

and

// Build a query:
$query = "SELECT * FROM listings WHERE MATCH trading AGAINST ('$searchValue')";

Because there's nothing there. I mean, I presume it's still saying "Query SELECT * FROM listings WHERE MATCH trading AGAINST ('') returned no results." when $searchValue is supposed to equal "test"...😕

phence

ahh.. this is frusterating.

Thank-you for your help though. I dunno what else to do but try it on another server with different configurations... but i kinda need to have this up and running within the weeks end.

Once agian THANK-YOU for your time and concern,
Sean

phence

Okay Looked over mysql configuration... no problems

What can i do now?

Are their any specific configuration i should be lookng for?