[SOLVED] Selecting values from a mysql table

[Demonic]

Alright I have a table called "general"

 

 

There aren't any unique id's, is there a faster way of getting all the options and values from the generals table without having to define the name and using a foreach e.g..:

 

pseudo

$array = array();

$fields = array('domain','download_index',..etc.);

foreach($fields as $field) {

select blah from blah and append to the $array[$field] = $value

}

 

Is there a faster way of doing this?

[pocobueno1388]

You just want to display everything from the "option" field? It's as simple as this:

 

<?php

$query = mysql_query("SELECT option FROM table")or die(mysql_error());

while ($row = mysql_fetch_assoc($query)){
   echo $row['option'] .'<br />';
}

?>

[Demonic]

thanks much, will give this a try and thats basically all I want to do.