Re: new set of eyes?

I should probably clarify a bit more on the data in the field and what I am trying accomplish.. First the data: host dhcp-01 { hardware ethernet 00:D0:B7:BD:D2:8D; fixed-address 155.97.1.190; } host dhcp-02 { hardware ethernet 00:02:B3:A2:B6:FD; fixed-address 155.97.1.191; } Second the plan: Trying to break up (only one row in database & always will be only one row to retrieve) contents of field into an array so I can break it down into individual editable fields (eg. <input type=\"text\" name\"$host\"> etc.) the explode() is so I can separate numerous static dhcp hosts into one big array of each setting. eg. $hosts = array("0" => "host",

               "1" => "dhcp-02",
               "2" => "{",
	       "3" => "hardware",
               "4" => "ethernet",
               "5" => "00:02:B3:A2:B6:FD",
	       "6" => ";",
	       etc...

I hope this clarifies my problem. I have tried a few things such as a eregi statement, explode etc. and so far explode has done what i need it to by separating one db entry into multiple components for editing. Jas David Otton wrote:

On Sat, 06 Dec 2003 11:38:18 -0700, you wrote:

I think I am loosing my mind this afternoon... could someone review this snippit and tell me why it isn't working? $sql = mysql_query("SELECT $i FROM $table WHERE $i = $i",$db)or die(mysql_error()); while($b = mysql_fetch_array($sql)) { while($ar = current($b) != 0) { $v = array(); list($v) = explode("}",$ar); } print_r($v); } I am hoping to get something like array([0]=>first row of data[1]=>second row of data)

Your code doesn't have any context, so I can't be sure whether you're doing something very smart or very dumb with the SQL statement. The explode() is kinda weird, too. Try running this: <? $sql = "SELECT $i FROM $table WHERE $i = $i"; echo ($sql); $rs = mysql_query ($sql, $db) or die (mysql_error ()); $result = array(); while ($row = mysql_fetch_array ($rs)) { $result[] = $row; } print_r ($result); ?> and let us know how close it comes.