hallo,
hoe kan ik zorgen dat alle table namen in mijn datbase in een dropdown boxje komen?
M.v.g. zap
718 views
bedankt maar hoe kan ik dit dan:
[code]
SHOW [FULL] TABLES [FROM db_name] [LIKE 'pattern']
[code]
in een dropdown box zetten?
[code]
SHOW [FULL] TABLES [FROM db_name] [LIKE 'pattern']
[code]
in een dropdown box zetten?
<?php
//mysql_connect & mysql_select_db etc.
$result = mysql_query("SHOW TABLES") or die(mysql_error());
echo '<select>';
while($row = mysql_fetch_row($result)) {
echo '<option value="'.$row[0].'">'.$row[0].'</option>';
}
echo '</select>';
?>
//mysql_connect & mysql_select_db etc.
$result = mysql_query("SHOW TABLES") or die(mysql_error());
echo '<select>';
while($row = mysql_fetch_row($result)) {
echo '<option value="'.$row[0].'">'.$row[0].'</option>';
}
echo '</select>';
?>