[SOLVED] Loop Question

[Zepo.]

$con=mysql_query("SELECT name,value FROM configuration");
while(list($name,$value)=mysql_fetch_row($con)){
$config[$name]		='$value';
}

 

 

Is This Possible?

[kenrbnsn]

Yes, except you don't want the single quotes around $value.

 

Ken

[Zepo.]

Well im trying to define $config[namehere] to the value but it's not working for some odd reason.

[kratsg]

$con=mysql_query("SELECT name,value FROM configuration");
while(list($name,$value)=mysql_fetch_row($con)){
$config[$name]		='$value';
}

 

Well, it's interesting that you would use the list variable to do it (ironically). My way of doing it, since it seems much simpler (and I've honestly never understood list() function itself or its purpose) would be the following:

 

$con=mysql_query("SELECT name,value FROM configuration");
$config = array();
while($row=mysql_fetch_array($con)){
$name = $row['name'];
$value = $row['value'];
$config[$name] = $value;
}

 

That seems to be a little bit better for me to understand, I honestly don't like/understand list();.

[Zepo.]

Ok so i did this but no-go

$con=mysql_query("SELECT name,value FROM configuration");
while(list($name,$value)=mysql_fetch_row($con));

foreach(mysql_fetch_row($con) as $key => $value)
{
    $config[$name] = $value;
}

[Zepo.]

And krats g is the winner!

Thank you sir.

[kratsg]

TYVM :-D