Jon Westcot wrote:
> Hi Chris:
>
...
> That is, I need to close the single quote, place a comma after the
> field, and then add in another opening quote. One other thing: I suspect I
> need to use addslashes() to the elements in $data -- is there a way to do
> this with one statement as you've done above?
something like:
"INSERT INTO foo (fields) VALUES ('".join("','", array_map('mysql_real_escape_string', $data)."')";
>
>> Also as someone else suggested if this is a csv file you
>> can use LOAD DATA INFILE to directly import it instead
>> of having to create a bunch of insert queries.
>>
>> See http://dev.mysql.com/doc/refman/5.1/en/load-data.html
>>
>> Only do this if you are 100% sure of the data (ie it it sanitized in
>> some other step).
>
> Trying to use LOAD DATA INFILE was my initial plan, but that simply
> didn't work. Turns out that it's because of being on a shared server. I've
> talked with The Powers That Be about this and they're going to move to a
> dedicated virtual server; that should give me much more flexibility and
> control over what I need to update in the various settings and files and
> things to get past all of the heartburn I've had over the last weeks.
>
>>> As odd as this sounds, should I put in some type of
>>> delay? Could the system be thinking it's getting flooded
>>> by all of the inserts?
>> Doubt it.
>
> Surprisingly enough, when I've used something like usleep(15000), I seem
> to be able to process more records than when I don't have it at all.
> ::shrug:: Just clutching at straws.
>
> Thanks again for your comments. I appreciate them all!
>
> Jon
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
