Re: [PHP] HOW DO U SPLIT UP LARGE STRINGS?

well, it must be big as it says 'mysql server gone away' i cant open the file from mysql, i need to edit a few things each line. i suppose i could open it, then save it to disk and then run that mysql command "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > hello,

Re: [PHP] HOW DO U SPLIT UP LARGE STRINGS?

John Ryan wrote: I've a string with a huge mySQL query, seperated by a semi-colon and then line-break. You can't run this query staright to mySQL (and i dont want to try), so Im trying to split up the query into, say, 100 mysql commands at a time. Is it possible to split up a string every 100 semi

Re: [PHP] HOW DO U SPLIT UP LARGE STRINGS?

hello, you can use the split() method to break this up into pieces. Unless you are doing a large number of inserts on tables with several keys mysql will not be troubled too much by the number of queries you run. John Ryan wrote: I've a string with a huge mySQL query, seperated by a semi-colon

[PHP] HOW DO U SPLIT UP LARGE STRINGS?

I've a string with a huge mySQL query, seperated by a semi-colon and then line-break. You can't run this query staright to mySQL (and i dont want to try), so Im trying to split up the query into, say, 100 mysql commands at a time. Is it possible to split up a string every 100 semi-colons it finds?