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
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);
Actually it did just loop. I need to test again.
The insert statement is the the one $query =
So it's after yes, but contained in the braces, like
you diagram below.
Stuart
--- "Matt M." <[EMAIL PROTECTED]> wrote:
> where is your insert statement? I am guessing it is
> after your loop
>
>
where is your insert statement? I am guessing it is after your loop
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p ) {
$query = "INSERT INTO Profiles_Industries (ProfileID,IndID) VALUES
($LID, $p)";
/This is where y
Yep, I had found it shortly before.
Only it's not looping. It is taking last value only.
Stuart
--- "Matt M." <[EMAIL PROTECTED]> wrote:
> if ( is_array( $_SESSION['l_industry'] ) ) {
> foreach ( $_SESSION['l_industry'] as $p ) {
> $query = "INSERT INTO Profiles_Industries
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'] ) )
--
Where would that go?
Stuart
--- "Matt M." <[EMAIL PROTECTED]> wrote:
> > if ( is_array( $_SESSION['l_industry'] ) ) {
> > foreach ( $_SESSION['l_industry'] as $p )
> {
> > $query = "INSERT INTO Profiles_Industries
> (ProfileID,
> > IndID)
> > VALUES ($LID, $p)";
> > }
>
> do you have a
> if ( is_array( $_SESSION['l_industry'] ) ) {
> foreach ( $_SESSION['l_industry'] as $p ) {
> $query = "INSERT INTO Profiles_Industries (ProfileID,
> IndID)
> VALUES ($LID, $p)";
> }
do you have a } for the if statement?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Trying to get array of values into table.
Each value will be part of a new record, so it's a
loop.
I am getting a parse error though and for further down
in the code though I know this is what's causing it.
Is there anything wrong with this statement ?
if ( is_array( $_SESSION['l_industry'] ) )