Showing number of records returned after search

[jasone]

Hi all,

ive got a search working, as shown below... on the page i want to show how many records are returned, im sure this is pretty simple but cant really work it out.

any help or advice would be much appreiciated :-)

  <?php
    include "flowermatchdbcnx.php";
     $r = $_POST['occcas']; //users choice... e.g. birthday, anniversary etc.
     $s = $_POST['style']; //display type... modern or classic.
     $p = $_POST['price']; //price, need to be within the price range. 
     $t = $_POST['type']; //flower suitability.... mother father collegue etc.
     $pak = $_POST['pacakge']; //flowers packaging
 
    //The query to the database
 
 
 
    $query = ("SELECT * FROM products WHERE style IN ('$s') AND occcas IN ('$r') AND type IN ('$t') AND pacakge IN ('$pak') AND price IN ('$p')");
 
switch ($p){
    case "1":$query=($query." WHERE Price BETWEEN 0 AND 20");break;
    case "2":$query=($query." WHERE Price BETWEEN 21 AND 30");break;
    case "3":$query=($query." WHERE Price BETWEEN 31 AND 40");break;
    case "4":$query=($query." WHERE Price BETWEEN 41 AND 50");break;
 
            }
 
 
    $result = mysql_query($query);
    //while loop to go through database table search all matching records.
 
    while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
 
    echo "name :{$row['Product_ID']} <br>";
    echo "type :{$row['style']} <br>";
 
 
}
 
?>
</body>
 

hope the code snippet above helps.

secondly, i may as ask while im here, ive had a problem searching for number ranges, i tried using the 'switch' statement above but it didnt work, so ive resorted adding a column stating 10 - 20 etc and it looks up that field in the table, what is the best way to search for a price range without changing the code above too much?
:-)
many thanks in advance

[Markus]

To the first question

i'm thinking you'd need the mysql_num_rows( )

Don't have time for the second question at the moment!

Hope that gets you someehwere.