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
> ([EMAIL PROTECTED]) 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
> >[EMAIL PROTECTED]
> >=========================================================
> > _____ __ /\
> > /_/_/_\ / |_/ \
> > /_/_/_ __ __ __ __ / \
> > \_/_/_\ /_/ /_/ /_/ /_/ \ _ /
> > ___\_\_\/ /_/_/_/ /_//\/_/ \_/ \/\_/
> > \_//_/_/ /_/_/_/ /_/ \/_/ 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
