[RESOLVED] trying to use explode

[rbblue8]

Hey..

I have a row in my mysql table called member_of_ladder.

in that row is data formatted like so Night lance; cool; test1; test2;

now what I'm looking to do is drop the ; and put the values into a drop down menue.

so..
where is what i have so far.

require('/homepages/13/d153872232/htdocs/nightlance.com/match/main_mysql.php');
   $string=("SELECT member_of_ladder from Users where username='$username'");
   $query=mysql_query($string, $db) or die ('error while getting a list of ladders for which you belong to. <br />'.mysql_error());

   while ($result=mysql_fetch_assoc($query))
   {
   $game=explode(";", $result['member_of_ladder']);
   echo '<option>'.$game'</option?';
   }

now that only gives me one option. and not all three. how come?

when i try and do an implode.... like so

require('/homepages/13/d153872232/htdocs/nightlance.com/match/main_mysql.php');
   $string=("SELECT member_of_ladder from Users where username='$username'");
   $query=mysql_query($string, $db) or die ('error while getting a list of ladders for which you belong to. <br />'.mysql_error());

   while ($result=mysql_fetch_assoc($query))
   {
   $game=explode(";", $result['member_of_ladder']);
   $test=implode(" ",$game);
   echo '<option>'.$test.'</option?';
   }

i get all the vaules seperated by a space... but they are not different options. instead they are all on one line.

can you help me??

[ClarkF1]

Try this:

while ($result=mysql_fetch_assoc($query))
   {
      $game=explode(";", $result['member_of_ladder']);
      foreach ($game as $value)
      {
          echo '<option>'.$value.'</option>';
      }
   } 

[laserlight]

in that row is data formatted like so Night lance; cool; test1; test2;

Time to rethink the design of that table.

Read PHPBuilder's article on Database Normalization And Design Techniques

[rbblue8]

auctally the design of that table is just fine!

perhaps is you knew what exactly that table holds... and the rest of the mysql structure you would understand why it's laid out like that.

but that's not relevent to this issue since my only issue is formatting the data comming out of my the mysql table.

ClarkF1,

i have tried your suggestion... and it does not work. after i do that... the drop down menue was empty.

so i tried this....

require('/homepages/13/d153872232/htdocs/nightlance.com/match/main_mysql.php');
   $string=("SELECT member_of_ladder from Users where username='$username'");
   $query=mysql_query($string, $db) or die ('error while getting a list of ladders for which you belong to. <br />'.mysql_error());

   while ($result=mysql_fetch_assoc($query))
   {
   $game=explode(";", $result['member_of_ladder']);
   foreach($game as $value)
   {echo '<option>'.$value.'</option?';}
   } 

and still nothing.. it's left blank.

[rbblue8]

lol,

never mind.. what i posted above worked just fine!

i had to log in as a user that had data in that table 🙂

lol.