|
|
Posted by G-Rod on 03/13/07 19:52
I seem to have figured out what my error was. It doesn't like an
apostrophe in the middle of one of my variables.
How do you insert something like "George's" into a field? Is there a
remove apostrophe's function?
On Mar 9, 8:15 pm, Rik <luiheidsgoe...@hotmail.com> wrote:
> G-Rod <futbol...@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 inserts
> >> > 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 stops.
>
> >> > 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're
> 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 help
> >> > me with this.
>
> >> What error do you get, and what code do you use?
> > function add_RAW()
> > {
>
> > for ($i=0; $i<count($budget); $i+=23){
>
> (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]
|