can any one see a problem with this loop?

  <?
$db = include"connect.inc";
$foo = "SELECT * FROM 6pci WHERE card='$card' ORDER BY card";

 $result = mysql_query($foo,$db); 


while ( ($myrow = mysql_fetch_array($result) ) ) {

$id = $myrow["id"];
$card = $myrow["card"];
$serial = $myrow["serial"];
$avail = $myrow["avail"];
$pn = $myrow["pn"];
$cat = $myrow["cat"];
$box = $myrow["box"];
$quote = $myrow["quote"];
}
?>

if i call say just $card it only displays the one record (the last one), the minute i 
try to call $myrow["card"]; i get nothing at all... any idea's?

I have script identical to this that works perfectly .. only difference is this one 
has different names for the values

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

Reply via email to