$connect = mysql_connect("$dbhost","$dbuser","$dbpass") or die(mysql_error()); mysql_select_db("$database" ,$connect) or die(mysql_error()); $query1 = "select context from exten"; $results = mysql_query($query1) or die(mysql_error()); while ($row = mysql_fetch_assoc($results)){ $cons = $row['context']; $connect = mysql_connect("$dbhost","$dbuser","$dbpass") or die(mysql_error()); mysql_select_db("$database" ,$connect) or die(mysql_error()); $query = mysql_query("select context,exten,priority,app,appdata from exten where context='$cons'", $connect) or die(mysql_error()); $file = fopen($exten, 'w'); while ( $row = mysql_fetch_assoc($query)){ #echo $row['exten']; $ext = "[".$cons."]\n" ."exten => " .$row['exten']."," .$row['priority']."," .$row['app'].",(" .$row['appdata'].")\n"; fwrite($file, $ext); } } // Out put [did] exten => 444,1,Dial,(sip/4037759931) 037759931) [default] exten => test,1,test,(test) // the way the out put should look [did] exten => 444,1,Dial,(sip/4037759931) exten => 444,2,Dial(h323/037759931) [default] exten => test,1,test,(test)