I am getting my data out of the database correct. What I am pulling is state abbr that a users has selected so I may get one or more for each. What I'd like to do is take that data then convert it into something like this: MD, CA, AL, FL. I have tried and tried but i either get the first state select or the last only. Any suggestions?

PHP Code:

$query = "select state.abbrv from person left join person_state_rep on person.id=person_state_rep.person_id left join state on state.id=person_state_rep.state_id where person.id=".$_POST["id"]." order by state.abbrv";
    if (mysql_connect($defaults["db_server"], $defaults["db_username"], $defaults["db_password"])) {
        if (mysql_select_db($defaults["db_database"])) {
            if ($result = mysql_query($query)) {
                if (mysql_num_rows($result) > 0) {
                    while ($sqldatarow = mysql_fetch_assoc($result)) {
                        $state_rep = $sqldatarow["abbrv"];
                    }

                }
                mysql_free_result($result);
            }
            else {
                die ("<h3>SQL Error #".mysql_errno()."</h3>\n<h4>".mysql_error()."</h4>\n<h4>Line ".__LINE__." in ".__FILE__."</h4>\n");
            }
        }
        else {
            die ("<h3>SQL Error #".mysql_errno()."</h3>\n<h4>".mysql_error()."</h4>\n<h4>Line ".__LINE__." in ".__FILE__."</h4>\n");
        }
    }
    else {
        die ("<h3>SQL Error #".mysql_errno()."</h3>\n<h4>".mysql_error()."</h4>\n<h4>Line ".__LINE__." in ".__FILE__."</h4>\n");
    } 


Use a switch:

{psudocode}

PHP Code:


function GetLong($state) 
{
  $state = (!get_magic_quotes_gpc()) ? addslashes($state) : $state;

  switch ($state) {
    case "CA":
      $state = 'California';
      break;    
    case "FL":
      $state = 'Florida';
      break;

// etc

  }
  return $state;
} 


Use the function in the following fashion, for e.g. in a loop..

PHP Code:


$thisState = $sqldatarow['abbrv'];

$state = GetLong($thisState);

echo $state; 


That just converts names - I think he wants a list of abbreviations:

tobeyt23, try this as a replacement for your inner loop:

PHP Code:

                   if (mysql_num_rows($result) > 0) {
   $statelist = array();
   while ($sqldatarow = mysql_fetch_assoc($result)) {
      $statelist[] = $sqldatarow["abbrv"];
   }
   $state_rep = implode(", ",$statelist);
  } 


That ought to add each of the abbreviations to an array called statelist. Then at the end the implode function will convert the array to a string, with each abbreviation separated by a comma and a space.