Re: baffled :<:<

""Peter Houchin"" <peterh@vfsa.com.au> wrote in message news:NFBBJNAGDIPHLCGPBLKDMEFKCDAA.peterh@sunrentals.com.au... > 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 you are doing print $myrow["card"] here, $myrow at this point is false, so that's why you see nothing. It's reset to false by the final $myrow = mysql_fetch_array($result). Here's wishing you more sleep and less debugging next time :-) Regards, John > ?> > > 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! ************** >