
24 Sep
2009
24 Sep
'09
5:27 p.m.
Unless your table "$table" is dynamic, you will encounter errors with all insets where column count is not valid assume $table is table_column-count then ... .. . while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $c = count($data); // get count of columns $table = "table_$c"; // concat table name $sqldata = ""; // empty sting for concatenation below foreach($data as $dat) $sqldata .= ', "'.msql_real_escape_string($dat).'"'; // convert $data into csv of quoted escaped values $sqldata = substr($sqldata,2); // remove first space and comma ", " if($c > 0 and $c <= 22) mysql_query("insert into $table values ($sqldata)", $connection); if($c ==12) echo "YIPEEEEE"; if($c > 22 or $c == 0) echo "Call your DBA - Mark"; } Ashford K.