Re: baffled :<:<

That's too easy! Chris Romulo Roberto Pereira wrote: > Even better, > > $id[] = $myrow["id"]; > > then count them: > > for ($i=0;$i < count($id);$i++) { > .. > } > > Rom > -----Original Message----- > From: Chris Fry [mailto:chris@quillsoft.com.au] > Sent: Tuesday, April 17, 2001 3:00 AM > To: Mark Maggelet > Cc: peterh@vfsa.com.au; php-general@lists.php.net > Subject: Re: [PHP] 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. > > -- > 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 > > -- > 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.