<?php $row mysql_query("SELECT COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME 'personne' AND COLUMN_NAME = 'situation'"); $res = mysql_fetch_array($row); preg_match_all( "/'(.*?)'/", $res[0], $val ); echo '<select multiple>'; foreach ($res as $res2) echo '<option value="'.$res2.'">'.$res2.'</option>'; echo '</select>'; ?>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question<?php $row mysql_query("SELECT COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME 'personne' AND COLUMN_NAME = 'situation'"); $res = mysql_fetch_array($row); $ca = preg_match_all( "/'(.*?)'/", $res[0], $val ); /*ça sert à quoi ?*/ echo ''; var_dump($ca); print_r($res); echo ' '; $select='<select multiple>'; foreach($res as $res2){ $select.='<option value="'.$res2.'">'.$res2.'</option>'; } $select.='</select>'; echo $select; ?>