Re: Array and insert statement throws error
| From: | Stuart Felenstein | Date: | Fri, 15 Oct 2004 21:01:09 +0000 |
| Subject: | Re: Array and insert statement throws error | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-36839@lists.php.net to get a copy of this message | ||
Hopefully these functions will explain it.
I'm starting the transaction, then provided it takes
with no errors it gets the commit
function begin()
{
mysql_query("BEGIN");
}
function commit()
{
mysql_query("COMMIT");
}
function rollback()
{
mysql_query("ROLLBACK");
}
begin();
$query = "INSERT INTO>...........
$result = mysql_query($query);
--- Brent Baisley <brent@landover.com> wrote:
> When are you actually performing the insert into the
> database? The code
> you posted is only changing the value of the
> variable $query. You also
> need to have the database function to insert into
> the database.
> Assuming it MySQL:
> ...
> foreach(...) {
> $query = "INSERT INTO ...";
> mysql_query($query);
> }
>
> On Oct 15, 2004, at 4:40 PM, Stuart Felenstein
> wrote:
>
> > Yep, I had found it shortly before.
> > Only it's not looping. It is taking last value
> only.
> >
> > Stuart
> >
> >
> > --- "Matt M." <h.dudeness@gmail.com> wrote:
> >
> >> if ( is_array( $_SESSION['l_industry'] ) ) {
> >> foreach ( $_SESSION['l_industry'] as $p ) {
> >> $query = "INSERT INTO Profiles_Industries
> >> (ProfileID,IndID) VALUES
> >> ($LID, $p)";
> >> } //foreach ( $_SESSION['l_industry'] as $p )
> >> } //if ( is_array( $_SESSION['l_industry'] ) )
> >>
> >> --
> >> PHP Database Mailing List (http://www.php.net/)
> >> To unsubscribe, visit:
> http://www.php.net/unsub.php
> >>
> >>
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit:
> http://www.php.net/unsub.php
> >
> >
> --
> Brent Baisley
> Systems Architect
> Landover Associates, Inc.
> Search & Advisory Services for Advanced Technology
> Environments
> p: 212.759.6400/800.759.0577
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>