Re: Array and insert statement throws error

[Brent Baisley <brent@xxxxxxxxxxxx>]

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@xxxxxxxxx> 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