Dean Vaughan

 
  function save() {
    if(!$this->id) {
 
### DUPE PREVENTION
      $sql = "SELECT id FROM users WHERE username = '" . $this->username . "' LIMIT 1";
      $db2 = mysql_query($sql);
      $db3 = mysql_fetch_array($db2);
      if($db3['id']) {
        return(0);
      }
 
### INSERT AND GET THE NEW ID
      $sql = "INSERT INTO users(`name`, `username`) " .
                  "VALUES('" . $this->name . "', '" . $this->username . "')";
      mysql_query($sql);
 
      $sql = "SELECT id FROM users WHERE name = '" . $this->name . "' " .
             "AND username = '" . $this->username . "' ORDER by username DESC LIMIT 1";
      $db2 = mysql_query($sql);
      $db3 = mysql_fetch_array($db2);
      $this->id = $db3['id'];
 
    }
 
    $to_set = '';
 
    foreach($this as $key => $value) {
      if($key == 'id') {
        continue;
      }
 
      if($key != -1) {
        if($to_set) {
          $to_set .= ', ';
        }
 
        if(is_array($value)) {
          $value = serialize($value);
        }
 
        $to_set .= "$key = '" . mysql_real_escape_string($value) . "'";
      }
    }
 

 
# $table: The mySQL table to use.
# $column: The column in $table to display
# $name: The HTML name of the drop down
# $selected: The value that the drop down defaults to.
# $show_any: If you have a row in the table where the $column equals
                    00_Any it will be displayed.
#                  This is useful for having an Any or All value.
# $distinct: Only show DISTINCT() $column
function dropdown_db($table, $column, $name, $selected,
                              $show_any = 1, $distinct = 0) { 
 
  $dropdown = "
<select id=\"$name\" name=\"$name\">\n"; 
 
  $any_sql = '';
  if(!$show_any) {
    $any_sql = " WHERE $column <> '00_Any' ";
  } 
 
  $select = $column;
  if($distinct) {
    $select = "DISTINCT($column)";
  } 
 
  $from_db = "SELECT $select FROM $table $any_sql ORDER by $column";
  $from_db2 = mysql_query($from_db) ;
  while($from_db3=mysql_fetch_array($from_db2, MYSQL_ASSOC)) { 
 
    $value = $from_db3["$column"]; 
 
    $pretty_db = $value;
    $pretty_db = str_replace('00_', '', $pretty_db);
    $pretty_db = str_replace('_', ' ', $pretty_db); 
 
    $SELECTED = '';
    if($value == $selected) {
        $SELECTED = ' SELECTED';
    } 
 
    $dropdown .= "<option value=\"$value\"$SELECTED>$pretty_db</option>\n";
  } 
 
  $dropdown .= "</select>
 
\n"; 
 
  return($dropdown);
}