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;
}[/php]
Once again many thanks,
Sam Joy