EDIT:
Code:
SHOW TABLES
Will give you back an array. Treat it as a standard query.
|
thanks
this statement does exactly what I want it to do, except I only want it to show the ones with CMS_ in front, and if possible, remove CMS_.
Code:
<select>
$result = mysql_list_tables(memem);
if(mysql_num_rows($result)) {
while($row = mysql_fetch_array($result))
{
echo"<option value=\"$row[0]\">$row[0] $row[category]</option>";
}
}
</select>