Hey, Using the hard limit of 4096, compare your array size with 4096 and limit the index to 4095. Anything above that split to another table. (PK-FK) Hope that helps! Oj. The optimist sees the doughnut; the pessimist the hole. --- On Thu, 9/24/09, Nicholas Loki <lokimwenga@yahoo.com> wrote: From: Nicholas Loki <lokimwenga@yahoo.com> Subject: Re: [Skunkworks] Iterate this for infinity To: "Skunkworks Forum" <skunkworks@lists.my.co.ke> Date: Thursday, September 24, 2009, 4:52 AM 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 -----Inline Attachment Follows----- _______________________________________________ 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