INSERT, UPDATE, QUERY from umm read on

[Anon]

Hello

I am pulling data out of an sql database using the mysql_num_rows($result) and mysql_num_fields($result)

I use the for loop within a while loop to display the information within the database inside textfields...

I am intending to update the database. but the thing is this, everything is unknown!!!

I don't know the fieldnames as this database will change daily with extra fields added and removed regularly...

multiple fields could've been added...
so on and so forth the database will be changed!

I guess what I'm trying to say is, how do I update the database with the array of data pulled out using mysql_num_fields() and mysql_num_rows()

Please help...

[Anon]

sorry that's MYSQL database MYSQL...
ummm yeah... please continue helping me...
please?

[khaine]

You need to make use of mysql_field_name().

<?

// database connection goes here

$query="select * from table where condition like 'target'";
$result=mysql_db_query($connection, $query);

while ( $fields=mysql_fetch_array($result, MYSQL_NUM) )
{
for ( $loop=0; $loop<count($fields); $loop++ )
{
if ( empty(mysql_field_name[$loop]) )
{
break;
}
echo "Field name is ".mysql_field_name[$loop];
echo " value ".$fields[$loop];
}
}

?>

You could use this to build a query using the field names to reinsert the data.

Mark.