baffled :<:<
| From: | Peter Houchin | Date: | Tue, 17 Apr 2001 05:59:37 +0000 |
| Subject: | baffled :<:< | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-48898@lists.php.net to get a copy of this message | ||
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
peterh@sunrentals.com.au
=========================================================
_____ __ /\
/_/_/_\ / |_/ \
/_/_/_ __ __ __ __ / \
\_/_/_\ /_/ /_/ /_/ /_/ \ _ /
___\_\_\/ /_/_/_/ /_//\/_/ \_/ \/\_/
\_//_/_/ /_/_/_/ /_/ \/_/ v
________ ________________________________________
/_/_/_/_/ /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
/_/_ _/_/ ______ __ __ /_/ ____ __ ______
/_/_/_/_/ /_/_/_/ /_/ /_/ /_/ /_/\_\ /_/ /_/_/_/
/_/ \_\ /_/ _/ /_//\/_/ /_/ /_/__\_\ /_/___ _\_\_\
/_/ \_\/_/_/_/ /_/ \/_/ /_/ /_/ \_\/_/_/_//_/_/_/
=========================================================
Telephone : (03) 9329 1455 Facsimile : (03) 9329 6755
************* We rent the dot in .COM! **************