$line) { //razbivaem stroku na polya i formiruem zapros $line_exp = explode("\t", $line); $sqlquery = 'INSERT INTO hotels VALUES ('; $sqlquery .= '""'; // id $sqlquery .= ',"'.$line_exp[0] . '"'; //hotel name $sqlquery .= ',"'.$line_exp[1] . '"'; // class $sqlquery .= ',"'.$line_exp[2] . '"'; // adress $sqlquery .= ',"'.$line_exp[3]. '"'; //area $sqlquery .= ',"'.$line_exp[4]. '"'; //perif $sqlquery .= ',"'.$line_exp[5]. '"'; //nomos $sqlquery .= ',"'.$line_exp[6]. '"'; //tel $sqlquery .= ',"'.$line_exp[7]. '"'; //fax $sqlquery .= ',"'.$line_exp[8]. '"'; //email $sqlquery .= ',"'.$line_exp[9]. '"'; //rooms $sqlquery .= ',"'.$line_exp[10]. '"'; //beds $sqlquery .= ')'; //echo $sqlquery.";
"; $result = mysql_query($sqlquery) or die(" $sqlquery failed!
".mysql_error()); } ?>