Search Result's Help

Okay so I am printing out my results of the search from a mysql database and I need to create code that if more than 3 results are fetched that it will create another page for it to load from. Here is my code and for any more information please don’t hesitate to ask.

[php] $raw_results = mysql_query(“SELECT * FROM clientInfo
WHERE (PC1 LIKE '%”.$query."%’) OR (PC2 LIKE ‘%".$query."%’) OR (PC3 LIKE ‘%".$query."%’) OR (PC4 LIKE ‘%".$query."%’) OR (PC5 LIKE ‘%".$query."%’) OR (PC6 LIKE ‘%".$query."%’) OR (PC7 LIKE ‘%".$query."%’) OR (PC8 LIKE ‘%".$query."%’)") or die(mysql_error());

    // * means that it selects all fields, you can also write: `id`, `title`, `text`
    // articles is the name of our table
    // '%$query%' is what we're looking for, % means anything, for example if $query is Hello
    // it will match "hello", "Hello man", "gogohello", if you want exact match use `title`='$query'
    // or if you want to match just full word so "gogohello" is out use '% $query %' ...OR ... '$query %' ... OR ... '% $query'
    if(mysql_num_rows($raw_results) > 0){ // if one or more rows are returned do following
        while($results = mysql_fetch_array($raw_results)){
        // $results = mysql_fetch_array($raw_results) puts data from database into array, while it's valid it does the loop
            echo "<fieldset><legend><p>".$results['companyName']."</p></legend><p>Tel: ".$results['number']."</p><p> Email: ".$results['email']."</p></fieldset>";
            // posts results gotten from database(title and text) you can also show id ($results['id'])

    else{ // if there is no matching rows do following
        echo "No results";
else{ // if query length is less than minimum
    echo "Minimum length is ".$min_length;

Once again many thanks,

Sam Joy

Sponsor our Newsletter | Privacy Policy | Terms of Service