[PHP] multiple record out put

[Peter Houchin]

Hiya,

I'm creating a page where the user can select multiple  options to query the DB with i 
am at the moment i can't get more than 1 record to  display from the db at all. If any 
one could offer soem suggestions i would be very grateful 



<?
//db connect info above
if ($Submit) {
        $rs = "SELECT * FROM machine WHERE avail='y' AND system='$system'";
        $result = mysql_query($rs);
        $system = mysql_result($result, 0, 'system');
    $serial = mysql_result($result, 0, 'serial');
    $availe = mysql_result($result, 0, 'avail');
                        echo "$system $serial $avail";
        }       
echo mysql_error();                     

?>
<form name="machine" method="get" action="<? echo $PHP_SELF;?> ">
  <table width="463" border="1">
    <tr> 
      <td width="21%">MODEL</td>
      <td colspan="2">Config</td>
      <td width="14%"> Available </td>
      <td width="12%">Weekly</td>
      <td width="14%">Monthly</td>
    </tr>
    <tr> 
      <td width="21%"> 
        <select name="system" size="3" multiple>
          <option value="sparc 5">Sparc 5</option>
          <option value="sparc 20">Sparc 20</option>
          <option value="ultra_1">Ultra 1</option>
          <option value="ultra 2">Ultra 2</option>
          <option value="ultra 5">Ultra 5</option>
          <option value="ultra 10">Ultra 10</option>
        </select>
        <input type="submit" name="Submit" value="Submit">

        </td>
  </tr>
</table>  <br>
  <br>
</form>
Peter Houchin
[EMAIL PROTECTED]
=========================================================
     _____                              __   /\
    /_/_/_\                            /  |_/  \
   /_/_/_    __  __  __   __          /         \
   \_/_/_\  /_/ /_/ /_/  /_/          \   _     /
 ___\_\_\/ /_/_/_/ /_//\/_/            \_/ \/\_/
 \_//_/_/ /_/_/_/ /_/ \/_/                    v
     ________   ________________________________________
    /_/_/_/_/  /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
   /_/_ _/_/ ______  __   __  /_/ ____      __     ______
  /_/_/_/_/ /_/_/_/ /_/  /_/ /_/ /_/\_\    /_/    /_/_/_/
 /_/  \_\  /_/ _/  /_//\/_/ /_/ /_/__\_\  /_/___ _\_\_\
/_/    \_\/_/_/_/ /_/ \/_/ /_/ /_/    \_\/_/_/_//_/_/_/
=========================================================
Telephone : (03) 9329 1455  Facsimile : (03) 9329 6755
************* We rent the dot in .COM!  **************