Show some tables from mysql database

[kristian_gl]

Hello, need to show some of the tables in my database in a list/meny. At any given time I don't know how many tables there are in the DB, and what names they got, only which tables I don't wanna show (which are always the same).

 

In the code below, I manage to show all the tables:

 

$sql = "SHOW TABLES FROM oddl";
$result = mysql_query($sql);
?>
<form method="POST" action ="../admin/forhaandsvisning.php"> 
<p><select name="undersokelser" size="15" id="undersokelser">
          
<?php
	  while($row = mysql_fetch_row($result))
	  {
?>
  
<option value="<?php echo $row[0];?>"><?php echo $row[0];?></option>

<?php		
}
?>
</select>  

 

Any ideas?

[litebearer]

$x = array of table not to show

$y = array of all tables

$z = array_diff($y,$x) these are the ones you want to show

[kristian_gl]

can you show me in the code where to put it. Sorry, but i'm not that good with PHP

[litebearer]

Untested, but it should work...

$x = array() // fill this array with the names of  tables not to show

$sql = "SHOW TABLES FROM oddl";
$result = mysql_query($sql);
$i=0;
while($row = mysql_fetch_array($result)){
  $y[$i] = $row['0']; // in the row[] it should be the number that is the field containing the table name
$i++;
}
$z = array_diff($y, $x); // this produces an array of table names NOT in the exclude list
$num = count($z); // the number of table names to be used

?>
<form method="POST" action ="../admin/forhaandsvisning.php"> 
<p><select name="undersokelser" size="15" id="undersokelser">
<?php
$i = 0;
while($i<$num) {
?>
<option value="<?php echo $z[$i];?>"><?php echo $z[$i];?></option><br>
<?php 
  $i++;
}
?>
</select> 

[kristian_gl]

thanks, that worked just fine. just one tiny problem, in the list/meny, there are some empty spaces, which you can select where the tables that are not showing just to be

[litebearer]

Not sure, but you may need to reindex the $z array