Retrieving (Data + Fieldnames) from database to array?

[Josep]

Hi,

I'd like to poll a database and get the table contents, as well as the field
names from that table. I've been to php.net but this time I cannot find
something helpful.

I can get the data, and retrieve it into an array noproblem. [1]

I can get the data+fieldnames and put it into a list. [2]

But I cannot seem to be able to fill an array with the data *and* the
fieldnames. If you check both chunks of code, you will se what I'm doing.

Any hint? Any URL? Thank you in advance.

---------------------------------------------------
[1]
// Build SQL query
$query = "SELECT * FROM $table ORDER BY $sort_by";
$result = mysql_query($query) or do_error('list_AETitles()::mysql_query()',
'mysql query failed', mysql_error());
// Make sure there's something to show

// Call a function to build the table headers
insert_table_headers();

// Show results
while($row = mysql_fetch_array($result))
{
print "<TR ><TD ><A HREF=\"edit.php?id=$row[id]\">#$row[id]</a></TD>";
$high > $row[id] ? $high = $high : $high = $row[id];
for ($i=1; $i <= $columns; $i++)
{
print "<TD >$row[$i]</TD>";
}
print "</TR>\n";
}
print '</TABLE><BR>';
---------------------------------------------------
[2]
// Build SQL query
$query = "SELECT * FROM $table ORDER BY $sort_by";
$result = mysql_query($query) or do_error('list_AETitles()::mysql_query()',
'mysql query failed', mysql_error());
// Make sure there's something to show
$row = mysql_fetch_array($result, MYSQL_ASSOC);

// Show results
print '<table>';
while ($ary = mysql_fetch_assoc($result))
{
print '<tr>';
// $key is the column name. $val is the value
while (list($key,$val) = each($ary))
{
print '<TD class="'.$tblcolor.'">' .$val.'</TD>';
}
print '</tr>';
}
print '</table><br>';

--
Josep

[2metre]

"Josep" <jo***@easternrad.com> wrote in message
news:0P******************@newsread1.prod.itd.earth link.net...

Hi,

I'd like to poll a database and get the table contents, as well as the field names from that table. I've been to php.net but this time I cannot find
something helpful.

I can get the data, and retrieve it into an array noproblem. [1]

I can get the data+fieldnames and put it into a list. [2]

But I cannot seem to be able to fill an array with the data *and* the
fieldnames. If you check both chunks of code, you will se what I'm doing.

Any hint? Any URL? Thank you in advance.

---------------------------------------------------
[1]
// Build SQL query
$query = "SELECT * FROM $table ORDER BY $sort_by";
$result = mysql_query($query) or do_error('list_AETitles()::mysql_query()', 'mysql query failed', mysql_error());
// Make sure there's something to show

// Call a function to build the table headers
insert_table_headers();

// Show results
while($row = mysql_fetch_array($result))
{
print "<TR ><TD ><A HREF=\"edit.php?id=$row[id]\">#$row[id]</a></TD>";
$high > $row[id] ? $high = $high : $high = $row[id];
for ($i=1; $i <= $columns; $i++)
{
print "<TD >$row[$i]</TD>";
}
print "</TR>\n";
}
print '</TABLE><BR>';
---------------------------------------------------
[2]
// Build SQL query
$query = "SELECT * FROM $table ORDER BY $sort_by";
$result = mysql_query($query) or do_error('list_AETitles()::mysql_query()', 'mysql query failed', mysql_error());
// Make sure there's something to show
$row = mysql_fetch_array($result, MYSQL_ASSOC);

// Show results
print '<table>';
while ($ary = mysql_fetch_assoc($result))
{
print '<tr>';
// $key is the column name. $val is the value
while (list($key,$val) = each($ary))
{
print '<TD class="'.$tblcolor.'">' .$val.'</TD>';
}
print '</tr>';
}
print '</table><br>';

--
Josep

I'm not sure where you're having a problem but does this help?
(ie use of "mysql_field_name")

PRINT "<table>\n";

if ($row = mysql_fetch_array($result)) {
$iflds = mysql_num_fields($result) - 1;
print " <TR>\n";
for ($i = 0; $i <= $iflds; $i++){
print " <TH>".mysql_field_name($result, $i)."</TH>\n";
}
print " </TR>\n";
do {
print " <TR>\n";
for ($i = 0; $i <= $iflds; $i++){
print " <TD>$row[$i]</TD>\n";
}
print " </TR>\n";
} while($row = mysql_fetch_array($result));
} else {print "<font color=red>Sorry, no records were
found</font>";}
PRINT "</table>\n";
}

[Josep]

2metre va escriure:

I'm not sure where you're having a problem but does this help?
(ie use of "mysql_field_name")

doh!

Thank you very much 2metre! It was under my nose but I had my eyes closed (or
almost).

--
Josep

[TC Office Assisstant]

Josep sikyal:

Hi,

I'd like to poll a database and get the table contents, as well as the field
names from that table. I've been to php.net but this time I cannot find
something helpful.
I know that this problem was already solved, but the solution seems
unnecessarily complex to me. In reality, I don't understand what your
problem is, since you've stated it rather oddly, and I think that you
already had your solution but didn't know it.

I can get the data, and retrieve it into an array noproblem. [1]

I can get the data+fieldnames and put it into a list. [2]

But I cannot seem to be able to fill an array with the data *and* the
fieldnames. If you check both chunks of code, you will se what I'm doing.
I don't understand how this problem is different from [2]. If you use
mysql_fetch_assoc(), you'll get an array of fieldname => data pairs--isn't
this exactly what you want?

[2]
// Build SQL query
$query = "SELECT * FROM $table ORDER BY $sort_by";
$result = mysql_query($query) or do_error('list_AETitles()::mysql_query()',
'mysql query failed', mysql_error());
// Make sure there's something to show
$row = mysql_fetch_array($result, MYSQL_ASSOC);

// Show results
print '<table>';
while ($ary = mysql_fetch_assoc($result))
{
print '<tr>';
// $key is the column name. $val is the value
while (list($key,$val) = each($ary))
{
print '<TD class="'.$tblcolor.'">' .$val.'</TD>';
}

It's more readable to say

foreach ($ary as $field => $val) {
// Print table element
}

Within that loop you have $field as the name of the current column--what
else do you need?

If you want to print a header row with the names of fields, you can do
something like this at the beginning of your table:

print "<tr>"
while ($field = mysql_fetch_field($result)) {
print "<th>$field->name</th>";
}
print "</tr>";

This is somewhat similar to what the other poster wrote.
Jesse S. Bangs ja****@u.washington.edu