$query_klient = 'select `value_klient`, `jmeno_klient` from '.SQL_DBNAME.'.tbl_klient where zobrazit_klient = "1" order by poradi_klient;';

$result_klient = mysql_query($query_klient, $link) or die ('SQL dotaz nešlo provést');



echo '<select onchange="this.form.submit()" size="" name="klient" value="" style="width: 300px; height: 24px; background: #B4A48C; color: #272424; text-align: left; border: 0; font-size: 13px; font-family: Verdana;" >';



while($row=mysql_fetch_assoc($result_klient)) {

if ($klient == $row["jmeno_klient"])

{echo '<option value="'.$row["value_klient"].'" selected>'.$row["jmeno_klient"].'</option>';}

else {echo '<option value="'.$row["value_klient"].'">'.$row["jmeno_klient"].'</option>';}

}



echo '</select>';

CREATE TABLE IF NOT EXISTS `tbl_klient` (

  `id_klient` int(10) NOT NULL auto_increment,

  `jmeno_klient` varchar(64) NOT NULL,

  `value_klient` varchar(64) NOT NULL,

  `poradi_klient` smallint(4) NOT NULL,

  `zobrazit_klient` smallint(2) NOT NULL,

  PRIMARY KEY  (`id_klient`)

) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;