|
|
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
Navigation:
[Reply to this message]
|