Select Distinct if existing

[chaosuk]

Hi guys,

 

using the code below within an admin panel to create a drop down allowing the user to select the profiles they wish to assign to the record they're creating, problem we have is that once a record is created, if they need to edit it for what ever reason the selected profile option isn't sticking. I've played around with lots of variants of if existing_record to try and get it add selected="selected" into the code but failed at every attempt, any advice gratefully received.

 

<?php

// List only breeder profiles in the database

  echo '<select name="profile" class="textinput noborder">';
  echo '<option value="any">Any</option>';

        $qryGetDistinctProfile = "SELECT * FROM profiles ORDER BY title ASC";
        $resGetDistinctProfile = mysql_query($qryGetDistinctProfile,$connection) or die(mysql_error());

        if(mysql_num_rows($resGetDistinctProfile) > 0){

		$id       =  mysql_result($resProfile, 0, "id");
          
         while ($row = mysql_fetch_assoc($resGetDistinctProfile)){
		           
          echo  '<option value="'.$row['id'].'" >'.$row['title'].'</option>';

         }

        }

  echo '</select>';
?>

[darkfreaks]

http://www.phpro.org/tutorials/Dropdown-Select-With-PHP-and-MySQL.html

[chaosuk]

Thanks, but not working 

 

Getting the following error:

   

Fatal error:  Class 'DB' not found in on line 976

 

[darkfreaks]

http://stackoverflow.com/questions/1202712/mysql-database-config-in-a-seperate-class

[chaosuk]

So as I'm already calling the config info via an include at the top of the page I'm guessing I can edit that row to remove the DB connection class?

[darkfreaks]

you can edit the config info into the class yes. and just use that.