Re: baffled :<:<

This loop will only return the last record from the db as the variables are getting overwritten each time through the loop. It would make more sense to make each variable an array eg: $id[$i] = $myrow["id"]; or do something with each set of info inside the loop. Chris Mark Maggelet wrote: > On Tue, 17 Apr 2001 15:59:37 +1000, Peter Houchin > (peterh@vfsa.com.au) wrote: > >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) > > if you call it after the loop you mean? thats what i would expect to > be there. > > >the minute i try to call $myrow["card"]; i get nothing at > >all... any idea's? > > outside the loop again? well if the last call to mysql_fetch_array() > returns false, then that sounds right too. you probably mean to do > something inside the loop. here's another tip, use extract: > > while ( ($myrow = mysql_fetch_array($result) ) ) { > extract($myrow); > echo $card."<br>\n"; > } > > >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! ************** > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Chris Fry Quillsoft Pty Ltd Specialists in Secure Internet Services and E-Commerce Solutions 10 Gray Street Kogarah NSW 2217 Australia Phone: +61 2 9553 1691 Fax: +61 2 9553 1692 Mobile: 0419 414 323 eMail: chris@quillsoft.com.au http://www.quillsoft.com.au You can download our Public CA Certificate from:- https://ca.secureanywhere.com/htdocs/cacert.crt ********************************************************************** This information contains confidential information intended only for the use of the authorised recipient. If you are not an authorised recipient of this e-mail, please contact Quillsoft Pty Ltd by return e-mail. In this case, you should not read, print, re-transmit, store or act in reliance on this e-mail or any attachments, and should destroy all copies of them. This e-mail and any attachments may also contain copyright material belonging to Quillsoft Pty Ltd. The views expressed in this e-mail or attachments are the views of the author and not the views of Quillsoft Pty Ltd. You should only deal with the material contained in this e-mail if you are authorised to do so. This notice should not be removed.