php/mysql multiple select list box(beginner).

[sathyashrayan]

Dear group,
I have a task where I have to fetch datas from mysql and display it
in the multiple select list box. I have fetched the datas and it is
getting diplayed correctly in the multiple select box. I have used
some thing like this.

print "<select MULTIPLE SIZE='6' name='db_test[]'>";
while($row = mysql_fetch_obj ect($handle))
{

if($num 0) /*num is number of rows*/
{
print "<option value='$row->db_name'name=' $row->db_name'>".$ro w

>db_name."</option>";

}
}
print "</select>";

But I want to insert in mysql the selected values.That too the
multiselect in mysql. Do i have to use serilize function? Any link or
any implimentation snipits is very help full. Any key word to search
the google..? Thanks for any help.

[Jerry Stuckle]

sathyashrayan wrote:

Dear group,
I have a task where I have to fetch datas from mysql and display it
in the multiple select list box. I have fetched the datas and it is
getting diplayed correctly in the multiple select box. I have used
some thing like this.

print "<select MULTIPLE SIZE='6' name='db_test[]'>";
while($row = mysql_fetch_obj ect($handle))
{

if($num 0) /*num is number of rows*/

Why are you checking the number of rows? If none were returned, you
won't get here, anyway).

{
print "<option value='$row->db_name'name=' $row->db_name'>".$ro w

>db_name."</option>";

}
}
print "</select>";

But I want to insert in mysql the selected values.That too the
multiselect in mysql. Do i have to use serilize function? Any link or
any implimentation snipits is very help full. Any key word to search
the google..? Thanks for any help.

This part isn't clear. What exactly do you want to insert? Where do
you want to insert it?

Or an even better question - what are you really trying to accomplish?
Helping us understand that part will allow us to help you the best.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[Henk verhoeven]

sathyashrayan schreef:

Dear group,
I have a task where I have to fetch datas from mysql and display it
in the multiple select list box. I have fetched the datas and it is
getting diplayed correctly in the multiple select box. I have used
some thing like this.

print "<select MULTIPLE SIZE='6' name='db_test[]'>";
while($row = mysql_fetch_obj ect($handle))
{

if($num 0) /*num is number of rows*/
{
print "<option value='$row->db_name'name=' $row->db_name'>".$ro w

>db_name."</option>";

}
}
print "</select>";

But I want to insert in mysql the selected values.That too the
multiselect in mysql. Do i have to use serilize function? Any link or
any implimentation snipits is very help full. Any key word to search
the google..?

You could try:
database normalize