Version: 1.0
Type: Function
Category: Databases
License: GNU General Public License
Description: Sets a series of variables named from the column names to their values from a row.
function Columns2Vars ($db, $database, $row, $debug = 0) {
// Usage: Columns2Vars (SQL connection, database Name, current fetched row of database to set vars values to, 1 if you want to see the result);
$describe = mysql_query("DESCRIBE $database", $db);
$numFields = mysql_num_rows($describe);
while ($fields = mysql_fetch_array($describe) ) {
$temp = $fields["Field"];
global $$temp; ${$temp} = $row[$temp];
if ($debug) printf("var '%s'=value:'%s'<br />",$temp, ${$temp});
}
}
