Home > Archive > PHP Language > March 2004 > Display of fetched MySQL data?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Display of fetched MySQL data?
|
|
| W. D. 2004-03-26, 11:13 pm |
| 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!(TM) ->
http://www.US-Webmasters.com/best-start-page/
| |
|
|
|
| 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!)
>
u also need to fetch the results. See the php mysql manual
part for more info.
Mart
|
|
|
|
|