Can anybody shed some light on this minor problem.

I have a form, one of the fields has a list menu with 20 or so values.

The user can fill out the form and select one or more of the values from that list menu.

My problem is that if the user selects more than one value, only one value gets inputed into the database. How do I get more than one value from the list menu into the database.

I use phpmyadmin to access the database. Is it something to do with the "type" column in the table. At present it is set up as VARCHAR for that field.

If you need to see the site to see what I mean here's the link.

www.scottmason.co.uk/rnrf/main/members/login_database.php

Username - member
password - member

many thanks

Scott

Did it work?

sorry roddy, had to go out, i'll try it now

no it didn't work, I just got a blank screen this time

Da prob is dat i can test it properly. If u hve msn can u add me its

$topic1_results = "ALL";
if (isset($_GET['topic'])) {
$topic1_results = (get_magic_quotes_gpc()) ? ."%".$_GET['topic']."%". : addslashes(."%".$_GET['topic']."%";
}

Ok had a close look at it.
$topic1_results = "ALL";
if (isset($_GET['topic'])) {
$topic1_results = (get_magic_quotes_gpc()) ? ("%".$_GET['topic']."%" : addslashes("%".$_GET['topic']."%";
}

hoorah, it works!!!

Roddy thank you so much for your patience, this is what this forums all about, great.

As you've probably guessed i'm more a designer than a developer so if i can do anything for you, please just ask.