[Resolved] Making MySQL name my variables

[Kudose]

I was curious as to how I could make my variable names the same as the column name in MySQL. Basically so I wouldnt have to do something like this:

$var1 = $row['var1'];
$var2 = $row['var2']
$var3 = $row['var3'];
//etc...

This is just a guess. Could someone help me out on this?

<?php
  $sql = "SELECT * FROM table WHERE something='1'";
  $query = mysql_query($sql);
  $fetch = mysql_fetch_array($query);
  foreach($fetch as $f=>$v){
    ${$f} = $v;
  }
?>

[Drakla]

Use mysql_fetch_assoc()

$row = mysql_fetch_assoc($result);

foreach($row as $field => $val)
{
    $$field = $val;
}

fetch_array has numeric as well as associative keys, and if you're not going to use the numeric keys why waste the memory.

You could just as easily use extract($row), I suppose.

[Kudose]

I forgot all about extract(). :rolleyes:

Thank you. 🙂