Hi,
I am creating an online form which should take information to from one page using a multiple-select box then display the selected fields in order confirmation page. This part of the code works fine, Then I press the submit (complete order) button and the information should then get stored into the MySQL database as a string. So if I selected jan,feb and apr it will store into MySQL like jan,feb,apr all in the same field.

I think the main problem is that the information that is stored in the confirmation page is not being registered with the final order complete page.

Here is the code:

FirstPage:


Just a normal Multiple-select table.

Second page:


This is the code I use to display the select information from the table as a string.

Third Page:

This is the code that I am using to try and put the string into mysql



I have tried echo'ing the string and it does not display the it probably meaning there is something else wrong which I cannot find.

Any help will be appreciated.

Thanks

PS: I have got SESSION_Start on all the pages at the very top. Also the code does not display teh forms thats because I would be sending you about 700lines of code that is unnecessary.


all of the form headers look like this and are pointing to the correct php page.

Your code as posted (that's going into MySQL) is syntactically incorrect and would fail at compilation, so I've tried to guess a bit what's happening here, and therefore this could be wrong.

Can you (maybe) see the problem now?

$ilm = $_SESSION['info'];
foreach($ilm as $val)
{
    $ilmstring = implode(',' , $ilm);
    echo $ilmstring;
}
foreach($ilm as $val)
{
    $insert="INSERT INTO dealerguide (ilmissue) VALUES ('$ilmstring')";
}

Thanks,

I see what ive done wrong in that code but still the information doesnt seem to be registering with the session and entering information the string in mysql.

Anyone else able to shed some light on this?