note 51280 added to function.msql-list-tables
| From: | Kinfule at lycos dot es | Date: | Fri, 25 Mar 2005 16:41:30 +0000 |
| Subject: | note 51280 added to function.msql-list-tables | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-86984@lists.php.net to get a copy of this message | ||
Ah small function to get tables starting with a prefix
<?
function get_tables($prefix, $dbname)
{
$result = mysql_list_tables("$dbname");
$num_rows = mysql_num_rows($result);
for ($i = 0; $i < $num_rows; $i++)
{
$table = mysql_tablename($result, $i);
$todrop = ereg('^'.$prefix.'_', $table);
if ($todrop)
{
echo "<li>$table</li>";
}
}
mysql_free_result($result);
}
?>
----
Manual Page -- http://www.php.net/manual/en/function.msql-list-tables.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+51280
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+51280&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+51280&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+51280&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+51280&report=yes&reason=useless
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+51280&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+51280&report=yes
Search -- http://master.php.net/manage/user-notes.php