[Resolved] returning all the values from MySQL as $_POST vars

[perpetualshaun]

I think I've seen a way to do this, but I couldn't find it through a search in the forum here.

Let's say I pull ALL the fields from a MySQL table row, and I want to create $_POST variables of the same name for all the fields. What is the quickest, easiest way to do that? I have over 100 fields in this table, and I'm trying to avoid having to define every one of them.

Thanks,

Shaun

[devinemke]

do you just want the field names? if so:

$result = mysql_query('DESCRIBE table') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo $row['Field'] . '<br>';
}

[perpetualshaun]

Actually I'd like to get the name (Field) AND the value. Is that possible?

[Weedpacket]

Well, it's not often I suggest this but this is one case where it's valid:

SELECT * FROM the_table