Re: [PHP-DB] Display of fetched MySQL data?

2004-03-25 Thread Ryszard Hapka 
Hi!
use foreach (www.php.net/foreach).
Ryszard

W. D. wrote:

Hi Folks,

I am trying to display a list of retrieved records, but can't seem
to figure out how to do this properly.  Here is what I am aiming
for:
?

$result = mysql_query($SQLqry);

$NumRows = mysql_num_rows($result);

$NumFields = mysql_num_fields($result);

// Loop through each row
for ($RowIdx = 1; $RowIdx = NumRows; $RowIdx++)
 {
 Echo Record: .($RowIdx + 1).BR\n;
 // Loop through the fields
 for ($FieldIdx = 1; $FieldIdx = NumFields; $FieldIdx++) 
   {
   // Display the fields and associated data

   /*  What code goes here? */

   }
 } // End for ($RowIdx = 1; $RowIdx = NumRows; $RowIdx++)
?

How do I properly display the fieldname and its associated data?
I know that you can do something like this using foreach, but
I wanted a generic routine where you don't necessarily know
the fieldnames.
Any hints?  (Thanks if you do!)

Start Here to Find It Fast! - http://www.US-Webmasters.com/best-start-page/

 



--
?php
$me = array(
   name = Ryszard Hapka,
   mobile = 693 340 403,
   GG_number = 4765174,
   url_page = www.hary.rnet.pl
);
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Display of fetched MySQL data?

2004-03-25 Thread Ryszard Hapka 
not only foreach ;)

$r = mysql_query(select * from table);
while($t = mysql_fetch_assoc($r)) { // or while ($t = 
mysql_fetch_array($r)) -- you will see difrends
   foreach($t as $key = $value) {
   echo [.$key.] .$value .br /;
   }
   echo hr /;
}



Ryszard Hapka wrote:

Hi!
use foreach (www.php.net/foreach).
Ryszard

W. D. wrote:

Hi Folks,

I am trying to display a list of retrieved records, but can't seem
to figure out how to do this properly.  Here is what I am aiming
for:
?

$result = mysql_query($SQLqry);

$NumRows = mysql_num_rows($result);

$NumFields = mysql_num_fields($result);

// Loop through each row
for ($RowIdx = 1; $RowIdx = NumRows; $RowIdx++)
 {
 Echo Record: .($RowIdx + 1).BR\n;
 // Loop through the fields
 for ($FieldIdx = 1; $FieldIdx = NumFields; $FieldIdx++){
   // Display the fields and associated data
   /*  What code goes here? */

   }
 } // End for ($RowIdx = 1; $RowIdx = NumRows; $RowIdx++)
?

How do I properly display the fieldname and its associated data?
I know that you can do something like this using foreach, but
I wanted a generic routine where you don't necessarily know
the fieldnames.
Any hints?  (Thanks if you do!)

Start Here to Find It Fast! - 
http://www.US-Webmasters.com/best-start-page/

 





--
?php
$me = array(
   name = Ryszard Hapka,
   mobile = 693 340 403,
   GG_number = 4765174,
   url_page = www.hary.rnet.pl
);
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Display of fetched MySQL data?

2004-03-25 Thread W. D. 
Thanks!  mysql_fetch_assoc did the trick.


At 07:08 3/25/2004, Ryszard Hapka wrote:
not only foreach ;)

$r = mysql_query(select * from table);
while($t = mysql_fetch_assoc($r)) { // or while ($t = 
mysql_fetch_array($r)) -- you will see difrends
foreach($t as $key = $value) {
echo [.$key.] .$value .br /;
}
echo hr /;


Start Here to Find It Fast!™ - http://www.US-Webmasters.com/best-start-page/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Display of fetched MySQL data?

2004-03-24 Thread W. D. 
Hi Folks,

I am trying to display a list of retrieved records, but can't seem
to figure out how to do this properly.  Here is what I am aiming
for:

?

$result = mysql_query($SQLqry);

$NumRows = mysql_num_rows($result);

$NumFields = mysql_num_fields($result);

// Loop through each row
for ($RowIdx = 1; $RowIdx = NumRows; $RowIdx++)
  {
  Echo Record: .($RowIdx + 1).BR\n;

  // Loop through the fields
  for ($FieldIdx = 1; $FieldIdx = NumFields; $FieldIdx++) 
{
// Display the fields and associated data

/*  What code goes here? */

}
  } // End for ($RowIdx = 1; $RowIdx = NumRows; $RowIdx++)

?

How do I properly display the fieldname and its associated data?
I know that you can do something like this using foreach, but
I wanted a generic routine where you don't necessarily know
the fieldnames.

Any hints?  (Thanks if you do!)

Start Here to Find It Fast!™ - http://www.US-Webmasters.com/best-start-page/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php