Advertisement
Guest User

Untitled

a guest
Sep 24th, 2017
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.81 KB | None | 0 0
  1. echo "<select id='".$this->get_field_id( "groupID" )."' name='".$this->get_field_id( "groupID" )."'>";
  2.         echo "<option value=''>-- Select Ad Group --</option>";    
  3.         $query = "SELECT group_id, group_name FROM sbc_ads_group";
  4.         $result = mysql_query($query) or die(mysql_error());
  5.         $num_rows = mysql_num_rows($result);
  6.        
  7.        
  8.         while ($row = mysql_fetch_assoc($result)) {
  9.              $rows[] = $row;
  10.         }
  11.         for($i=0;$i<count($rows);$i++) {
  12.             if($rows[$i]["group_id"] == $groupID) {
  13.             echo "<option name='".$this->get_field_id( 'groupID' )."' value='".$rows[$i]["group_id"]."' select='selected'>".$rows[$i]["group_name"]."</option>";
  14.             } else {
  15.             echo "<option name='".$this->get_field_id( 'groupID' )."' value='".$rows[$i]["group_id"]."'>".$rows[$i]["group_name"]."</option>";
  16.             }
  17.         }  
  18.  
  19.        
  20.     echo "</select>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement