Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    New to the CF scene
    Join Date
    Sep 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclamation frustration with multipul results!

    I am trying to get this query to display multipul results.

    this is the error:
    -------------------------------------------------------------------
    Query SELECT * FROM listings WHERE MATCH trading AGAINST ('') returned no results.
    -------------------------------------------------------------------

    Also i have just noticed, no mater what the '$searchValue' is 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.

    I have been gouging out my eyes fro the past week in a half...

    heres the code:

    PHP SEARCH CODE
    -----------------------------------
    PHP Code:
    <?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 

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

    All Help is appreciated!!!
    Last edited by phence; 09-07-2002 at 06:42 AM.


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •