MySQL Field names as Var names

[Anon]

Hi

i will generally use this method to query MySQL:

$sql = "...SQL query...";
$res = mysql_query($res);

if($row = mysql_fetch_array($dbq)){
do{

[[deleted]]

.... and your question is?

[Anon]

ahh well, sometimes you hit TAB TAB ENTER and it just all slips away....

anyway, my question was going to be :

I am a tad bored of doing the usual :

$sql = "...some SQL query...";
$res = mysql_query($sql);
if($row = mysql_fetch_array($res)){
do {
$var1 = $row[0];
$var2 = $row[1];
$var3 = $row[2];
etc...etc..

is there any way to create a loop that takes the resultset, extracts the field names queried, then assigns $row[x] to $fieldname...I am terminally lazy....

[[deleted]]

Terminally lazy when it comes to reading the manual I think :-)

if you use
$aRow = mysql_fetch_array($res, MYSQL_ASSOC);

then you can reference the columns like:
echo $aRow['mycolumn'];

[amcgrath]

I do it this way, using Postgres

function fieldList() {
global $conn;
$query = "select * from order_detail limit 1";
$res = pg_exec($conn,$query);

$num_fields = pg_numfields($res);
for ($x = 0; $x <= $num_fields; $x++) {
$field_list[] = @pg_fieldname($res,$x);
}
return $field_list;
}

Not sure if that's what you mean though.

[dnszero]

$result = mysql_query("select model,color,price from cars where id=$id");

extract(mysql_fetch_array($result));

gives you vars name $model, $color and $price

[[deleted]]

Cool function.

But... it is generally not a good idea to put data from a database into globals. You can easily forget where the data came from or mix it up with data that came from somewhere else.

[Anon]

thats perfect! thankx

you can also use it as :

extract(mysql_fetch_array($result),EXTR_PREFIX_ALL, "dbq");

to prefix all result vars with dbq_

eliminating the chance of overwriting, and 'signing' each $var with a unique prefix that identifies it with the query....

awesome....