Hi need a bit of help!

[takn25]

Hi I bought a script to search mysql database and its working great. The thing I am after is I have a row called Now in my database. Now can either be 0 or 1  what I want the script to do is search something like && WHERE now='1'

the problem I am facing is the script is not well commented and the query part is kinda confusing could some one take a look and tell me what and where can I make the changes for the desired result thanks a bunch!

 

// table fields to search

  $arrayFields = array(0 => $first_field, 1 => $second_field, 2 => $third_field, 3 => $fourth_field );

  $countSearch = count($arraySearch);

  $a = 0;

  $b = 0;

  $query = "SELECT * FROM $table_name WHERE (";

  $countFields = count($arrayFields);

  while ($a < $countFields)

  {

    while ($b < $countSearch)

    {

      $query = $query."$arrayFields[$a] LIKE '%$arraySearch[$b]%'";

      $b++;

      if ($b < $countSearch)

      {

        $query = $query." AND ";

      }

    }

    $b = 0;

    $a++;

    if ($a < $countFields)

    {

      $query = $query.") OR (";

    }

  }

  $query = $query.") LIMIT $offset, $records_number;";

  $search = mysql_query($query);

 

 

// get number of search results

  $arrayFields = array(0 => $first_field, 1 => $second_field, 2 => $third_field, 3 => $fourth_field );

  $countSearch = count($arraySearch);

  $a = 0;

  $b = 0;

  $query = "SELECT * FROM $table_name WHERE (";

  $countFields = count($arrayFields);

  while ($a < $countFields)

  {

    while ($b < $countSearch)

    {

      $query = $query."$arrayFields[$a] LIKE '%$arraySearch[$b]%'";

      $b++;

      if ($b < $countSearch)

      {

        $query = $query." AND ";

      }

    }

    $b = 0;

    $a++;

    if ($a < $countFields)

    {

      $query = $query.") OR (";

    }

  }

  $query = $query.")";

  $count_results = mysql_query($query);

  $numrows = mysql_num_rows($count_results);

[QuickOldCar]

you add in your queries

 

AND now='1'

[takn25]

thanks I figured this much out but the problem I am facing is cant figure out the location where to insert and now='1' tried inserting in a few places but no luck :/

[takn25]

Never mind figured it out thanks a bunch!