Hi Skunks,

I think what Thea is looking for is a solution that will allow him to insert as many column items into a database table as there are tokens in the the $data array, which I assume is a line entry in a particular csv/text file. I would suggest that you use the $data array length as your limit. And concatenate a string representing your INSERT statement. Also it might be prudent to create your table before hand using the $data array length to determine the number of columns needed. Hope this helps some.

KR,

Loki

"Excellent people exceed expectations".

From: Frankline Chitwa <frank.chitwa@gmail.com>
To: Skunkworks Forum <skunkworks@lists.my.co.ke>
Sent: Thursday, September 24, 2009 10:54:46 AM
Subject: Re: [Skunkworks] Iterate this for infinity

just as you have done it. You have the $data variable, so use it as you had used it b4

On Thu, Sep 24, 2009 at 10:46 AM, thea maina <theamaina@gmail.com> wrote:

In your while loops, How is the $data from the CSV file been INSERTed INTO a new TABLE COLUNM?

On Thu, Sep 24, 2009 at 10:30 AM, Frankline Chitwa <frank.chitwa@gmail.com> wrote:

Maybe he wants to break the loop if he encounters a certain condition, and not necessarily go to the end of his data.
try
$loop = true;
while($loop){
$data = fgetcsv($handle, 1000, ",");
if($arraysize......................

//and to break the loop
if(condition){
$loop = false;
}
}

Be careful with this thoough. Make sure your condition always happens before the end of your data.

On Thu, Sep 24, 2009 at 9:21 AM, <ashok+skunkworks@parliaments.info> wrote:

On Thu, Sep 24, 2009 at 9:14 AM, thea maina wrote:
> Iterate this for infinity. - Hi guys, i hit a mind lock.. How can i iterate
> this for infinity.
> thanks
> ----------------------------------------------------------------
>
> while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
> {

maybe this ?

while (TRUE) {

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

but are you dealing with infinite data ?
_______________________________________________
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

--
www.dealcent.com - Your electronics shop
www.golavish.com - The travel and leisure
www.raccuddasys.com - code Development issues

_______________________________________________
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

--
www.dealcent.com - Your electronics shop
www.golavish.com - The travel and leisure
www.raccuddasys.com - code Development issues