Populate dropdown with stored array

Tim Schutz · #1 (**permalink**) 04-02-10, 11:48

My apologies. I cross-posted in the mySQL forum as well.

I have array data that was previously stored like so:

Code:

$allTeams=array('SF','CHI','CIN');
$userTeam=implode(',',$allTeams);
$query = "INSERT INTO users VALUES ('$userTeam')";

Now, I would like to populate a dropdown list with this array data. Here is what I have tried:

Code:

<select name="teamList" id="teamList">
<?php

include 'dbcon.php';

mysql_select_db($database, $conn);
	$query  = "SELECT userTeam FROM users WHERE fullName='Tim Schutz'";
	$result = mysql_query($query);
	while($row = mysql_fetch_assoc($result))
	{ 
	echo '<option value="' . $row['fullName'] . '">' . $row['userTeam'] . '</option>';
	}	

?>
</select>

The dropdown gets populated, but as one long string as a single item. I tried exploding the data, but nothing shows. Can anyone point me in the right direction?

mike_bike_kite · #2 (**permalink**) 04-02-10, 11:59

Quote:

Originally Posted by Tim Schutz

Can anyone point me in the right direction?

Do I understand you correctly ...
You've stored the value 'SF','CHI','CIN' into a table and now you're confused when you select the data from this table and it returns the value 'SF','CHI','CIN'.
Can I suggest you store the values separately and that you perhaps read up on normalisation

futurity · #3 (**permalink**) 04-02-10, 12:10

Either you're inserting your data wrong, or you table design is not normalized.

Here's what your INSERT looks like:

Code:

INSERT INTO users VALUES ('SF,CHI,CIN')

So what you're selecting is:

Code:

'Tim Schutz', 'SF,CHI,CIN'

What I'm assuming you want is:

Code:

INSERT INTO users VALUES ('SF'), ('CHI'), ('CIN')

Which would give you:

Code:

'Tim Schutz', 'SF'
'Tim Schutz', 'CHI'
'Tim Schutz', 'CIN'

However, this still won't help you build a correct select list, since you're going to end up with:

Code:

<select name="teamList" id="teamList">
  <option value="Tim Schutz">SF</option>
  <option value="Tim Schutz">CHI</option>
  <option value="Tim Schutz">CIN</option>
</select>

Sammach · #4 (**permalink**) 05-28-10, 03:37

i think the data insterted wrong

Internet Services

Web Development

Digital Marketing

Consumer Tech