This may not be what you want to do, but should give you some hints.
(This is my code which I use to simply dump any SQL table into an HTML
 table I can view in a browser ... for small tables, of course.)

Using MySQL as an example:
// assuming you ran a query and stored results in $mysql_result_set

// Get the number of fields to work with
$num_fields = mysql_num_fields( $mysql_result_set );

// Print out a row of column headers
print( "<tr>" );
for( $i = 0; $i < $num_fields; $i++ ){
        $fieldName = mysql_fetch_field( $mysql_result_set, $i );
        print( "<td>" . $fieldName->name . "</td>" );
print( "</tr>" );

// Print out the data from the result records
while( $record = mysql_fetch_row( $mysql_result_set ) ){
        print( "<tr>" );
        foreach( $record as $field ){
                ${$field} = $field;
                // The above is unnecessary, but answers your question.
                // It assigns a variable, named after a table column,
                //    the value of that column (in this record).
                print( "<td>${field}</td>" );
        print( "<tr>" );

Hope that gives you something to work with.


On Tue, 19 Feb 2002, Baloo :0) wrote:

> How can I assign automatically all fields of a database to a variable of
> the same name?
> Instead of having to manually do
> $user_id=$row["user_id"];
> etc
> Then how could I know the number of fields in the table so I can do a
> loop to print them all in html?

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to