PHP - Search, Sql Order By Priority Of The Searched Term ?

Here's the query:
Code: [Select]
$sql = mysql_query("SELECT * FROM resources WHERE gameCat = '' ORDER BY systemCat,order_id");
I want something to happen when the systemCat changes in the results. Like this:

Code: [Select]
if($row['systemCat'] CHANGES){
echo '<div id="seperator"></div>';
}

Any ideas? Thank you!

I would like to know how to do search terms. For example, someone key in the terms in the text field, and click search, thn it will show the data.

I've got a search page that spits out results that match the term that was input. Within the results, I want to add a span with a yellow background behind just the search term. I'll show my code, then say my problem

Code: [Select]
<?php
$search = (term in $_GET variable that was searched for);
// while loop that goes through all results, $result is the text that the searched term was found in
  $new_result = str_ireplace($search, "<span style='background:yellow'>$search</span>", $result);
  echo $new_result;
// end while loop
?>

my problem is that if somebody searches for the word "bob", then if the term "Bob" was found, when it outputs the $new_result, it shows as "bob" with the yellow background. Searching for "Bob" would give the correct results("Bob" with a yellow background), but basically when the output is given, the case of each letter is displayed as it was typed in the search field.

I want to let user to choose the checked box, so they will type in the words in the box, and select the radio button to limit their search. How should I approach it?

$search_words = mysql_real_escape_string($_POST['search_words']);
      
      $query =
      "SELECT name,login_id,password,email
      FROM User
      WHERE name LIKE '".$search_words."%'
      ORDER BY name ASC";
      // my query to display the necessary fields
      $result = mysql_query($query, $conn);//get results
      $result2 = mysql_query($query, $conn);//get results
      $resultCheck = mysql_result($result2,0,0);
      ?>
       
<p align="center" class="passwordsummary_header"> User's Password Summary
<table width="302" border="1" align="center">
  <tr>
    <td width="229">
    <form method="post" action="search.php" id="searchform">
<div align="center" class="label">
  <p>Search:
    <input name="search_words" type="text" id="search_words" size="30" maxlength="20" />
    <input type="submit" name="GO" id="GO" value="Go" />
  </p>
  <p>
  <input type = "radio" name = "namesearch" id = "namesearch"
value = "AM" <?php if($name == 'namesearch') {echo "checked";}?> >
name search</input>
   <input name = "loginidsearch" type = "radio" id = "loginidsearch" value = "loginidsearch" <?php if($login_id == 'loginidsearch') {echo 'checked';}?>>loginid search<br />
   <input type = "radio" id = "emailsearch" name = "emailsearch" value = "emailsearch" <?php if($email == 'emailsearch') {echo 'checked';}?>>
     email search </input>
   </div>
</form>
    </td>
  </tr>
</table>

</p>

   <?php   
      if ($search_words != "" && $resultCheck != "")
      {
      
      
      echo "<table width='650' border='1' align='center' cellspacing='1'>
 
     <tr><tr>
    <td class='passwordsummary_label'>No</td>
    <td class='passwordsummary_label'>Name</td>
    <td class='passwordsummary_label'>Login ID</td>
    <td class='passwordsummary_label'>Password</td>
    <td class='passwordsummary_label'>Email</td>
     </tr>";
      
      $i = 1;
         while ($row = mysql_fetch_row($result)) //use loop to get the results
         {
            $name = $row['0'];
            $login_id = $row['1'];
            $password = $row['2'];
            $email = $row['3'];
            ?>
<td class="passwordsummary_info"><?php echo $i;?></td>
            <td class="passwordsummary_info"><?php echo $name;?></td>
            <td class="passwordsummary_info"><?php echo $login_id;?></td>
            <td class="passwordsummary_info"><?php echo $password;?></td>
            <td class="passwordsummary_info"><?php echo $email;?></td>
            </tr>
            <?php $i++;
         }
         echo "</table>";
      }
      else
      {
      echo '<p class="results">No search results</p>';
      }

Hi guys,

I have this SQL query which I use in my PHP search script Code: [Select]
$query_for_result=mysql_query("SELECT * FROM customer WHERE c_name like '%".$query."%' OR c_telephone like '%".$query."%' OR c_address like '%".$query."%'");
It works fine, the only problem is now my database is bigger I would like to be able do SORT or ORDER BY id so that my search results are in order from asc to desc.

Is this possible? if so can you help me.

Thanks