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.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php