Posted by Rik on 03/10/07 03:15

G-Rod <futbolguy@gmail.com> wrote:
> On Mar 9, 5:34 pm, Rik <luiheidsgoe...@hotmail.com> wrote:
>> Anteater Alum <futbol...@gmail.com> wrote:
>> > I have financial data table in which I'm trying to insert rows with=

>> > approximately 30 columns of data. I am calling a function that inse=
rts
>> > a row for each financial transaction. There are about 120 rows that=
I
>> > need to insert, but only the first 30 are executing and then it sto=
ps.
>>
>> > I am passing the data to the function using a PHP array. The array
>> > contains about 2MB worth of data.

On a side note springs to mind a lot of hosters have a 2MB upload limit.=
=

How do you get the data, and can you verifiy it's all there before you'r=
e =

trying to insert it.

>> > I am getting frustrated wondering why it stops executing after row =
30,
>> > even when none of the column sizes are violated. I've read about
>> > 'max_allowed_packet' on mysql.com but I'm not sure if that applies.=

>>
>> > Any suggestions on other areas to look into would be greatly
>> > appreciated. Let me know if you need more specific information to h=
elp
>> > me with this.
>>
>> What error do you get, and what code do you use?

> function add_RAW()
> {
>
>
> for ($i=3D0; $i<count($budget); $i+=3D23){

(topposting fixed)

Euhm, where does this magic $buget come from? And what's the reason for =
=

this 23?

Also, I asked for an error message.
If you get none, please use this on top in your code:
ini_set('display_errors',true);
error_reporting(E_ALL);

> $this->query($add_RAW);

Does this object/method per chance have a method of checking wether a =

query succeeds, and/or what the error might be? Something along the line=
=

of:
if(!$this->query($add_RAW)) echo $this->error();

And what code does '$this->query()' use actually?

Seems to me a PHP issue, so crossposted & f'upped to c.l.php
-- =

Rik Wasmus
Posted on Usenet, not any forum you might see this in.
Ask Smart Questions: http://tinyurl.com/anel

[Back to original message]