Re: Array and insert statement throws error
| From: | Brent Baisley | Date: | Fri, 15 Oct 2004 20:51:19 +0000 |
| Subject: | Re: Array and insert statement throws error | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-36838@lists.php.net to get a copy of this message | ||
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