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 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??
I input this string from a text file through fopen while(fgets)? Is it easier to just read 100 lines at a time, run a query, and then read another 100 lines from the text file?
TIA
--
Raditha Dissanayake ------------------------------------------------------------- http://www.radinks.com/sftp/ Lean and mean Secure FTP applet with Graphical User Inteface. just 150 Kilo Bytes
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
