Indie-Resource.com

Code: Select all

<?php

include 'connect.php';

if(!isset($_SESSION)) { 
	session_start(); }

?>

<select name="title_select">
 
<?php

  $query = "SELECT DISTINCT char_title FROM titles";
  $result = mysql_query($query);
 while($row = mysql_fetch_assoc($result)){
			$title = $row['char_title'];			
			$title_options .= '<option>'.$title.'</option>';
			}

  $title_options .= '<option>'.$row.'</option>';

  echo "$title_options";
  
?>
 
 </select>

Code: Select all

<select name="title_select" onchange="javascript: this.form.submit();">

Code: Select all

<?php
include 'connect.php';
if (!isset($_SESSION)) {
    session_start();
}
?>

<form action="the address to submit to" method="post">
    <select name="title_select" onchange="javascript: this.form.submit();">
        <?php
        $query = "SELECT DISTINCT char_title FROM titles";
        $result = mysql_query($query);
        while ($row = mysql_fetch_assoc($result)) {
            $title = $row['char_title'];
            $title_options .= '<option>' . $title . '</option>';
        }
        $title_options .= '<option>' . $row . '</option>';
        echo "$title_options";
        ?>
    </select>
</form>