while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)

{

$insert_fmt = "INSERT INTO %s VALUES('%s')"; //string format

$values = join("','", $data); //join the pieces of the array without regard for array size

$table_name = "tbl";

$import = sprintf($insert_fmt, $table_name, mysql_escape_string($values));

mysql_query($import) or die(mysql_error());

}

Reference: http://www.php.net/manual/en/function.join.php - String function for joining the pieces of an array.

It goes without saying that you need to do the necessary validations to ensure that your queries don't trip up.

HTH

On Mon, Sep 28, 2009 at 8:57 AM, thea maina <theamaina@gmail.com> wrote:

Hi Ashford.
Thanks Man.
That might work..
I do create the table dynamically with varying columns and the first column is always a PK with a value..
i hope to dynamically populate it with some sample data.
I'll paste what works.
Any more help is appreciated..

regards

On Thu, Sep 24, 2009 at 5:27 PM, Ashford Kuria <kuriashford@gmail.com> wrote:

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.

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
Other services @ http://my.co.ke
Other lists
-------------
Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce
Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science
kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general

--
---------------------------------------------------------------------
Thea Maina
Nairobi Kenya
http://www.mafans.com
skype: thea.mnairobi

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
Other services @ http://my.co.ke
Other lists
-------------
Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce
Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science
kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general

--
blog: http://imma.wordpress.com