mjsnosk8

Hey thanks for the fast reply. Got me looking in the right direction. My work around is: User saves csv formated headers in the "profiles" table from a form. then I: $fo_w = fopen($H1datafile, 'w'); fwrite($fo_w, ''); fclose($fo_w); $fo_a = fopen($H1datafile, 'a'); $count = substr_count($header_row_1, ',') ; $i=0; while($i<=$count) { $data = "\'".'$data[' . $i . ']'."\',"; $i++; fwrite($fo_a, $data); } fclose($fo_a); $read = file($H1datafile); foreach($read as $line){ $header_data_1 = substr($line, 0, -1); } And store the value clause string $header_data_1 into the db. Later in the page I: $H1dataphp = 'temps/H1data.php'; $fo_w = fopen($H1dataphp, 'w'); $line1= '<?php while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){'."\n"; fwrite($fo_w, $line1); $line2 = '$insert = "INSERT into r_source_feed_1 ('.$header_row_1.') values('.$header_data_1.')";'."\n"; fwrite($fo_w, $line2); $line3 = 'mysql_query($insert) or die(mysql_error()); } ?>'; fwrite($fo_w, $line3); fclose($fo_w); Then include H1data.php on the page I need it. Now you can enter any number of headers in the text field and insert just those columns from a linked text file. MJ :D

Hi all, Just curious why this works: while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){ $import="INSERT into $prodtblname ($csvheaders1) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]')"; } And this does not: $headdata_1 = "'$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]'"; while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){ $import="INSERT into $prodtblname ($csvheaders1) values($headdata_1)"; } it puts $data[#'s] in the database fields instead of the actual data that '$data[0]','$data[1]'... relates to. I wrote a script to create the values in $headdata_1 based on the number of headers in $csvheaders1 but can't seem to get it working in the sql statement. Thanks