Connecting Tech Pros Worldwide Forums | Help | Site Map

php/mysql multiple select list box(beginner).

sathyashrayan
Guest
 
Posts: n/a
#1: May 10 '07
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_object($handle))
{

if($num 0) /*num is number of rows*/
{
print "<option value='$row->db_name'name='$row->db_name'>".$row
Quote:
>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
Guest
 
Posts: n/a
#2: May 10 '07

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


sathyashrayan wrote:
Quote:
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_object($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).
Quote:
{
print "<option value='$row->db_name'name='$row->db_name'>".$row
Quote:
>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@attglobal.net
==================
Henk verhoeven
Guest
 
Posts: n/a
#3: May 10 '07

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


sathyashrayan schreef:
Quote:
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_object($handle))
{
>
if($num 0) /*num is number of rows*/
{
print "<option value='$row->db_name'name='$row->db_name'>".$row
Quote:
>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

Closed Thread