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]

Re: php/mysql multiple select list box(beginner).

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.
jstucklex@attgl obal.net
=============== ===

[Henk verhoeven]

Re: php/mysql multiple select list box(beginner).

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