<?php
$sql=("alter table {$db_prefix}messages change message_id message_id int(10) unsigned not null auto_increment");
echo "message limit increased";
?>
<?php
opentable("Table Structure");
$result = mysql_query("SHOW COLUMNS FROM {$db_prefix}messages");
if (mysql_num_rows($result) > 0) {
echo "<table cellspacing='1' cellpadding='0' class='tbl-border'>\n<td colspan='2' class='tbl2'><b>Submissions Table Scheme</b></td>\n";
while ($row = mysql_fetch_array($result)) {
echo "<tr><td class='tbl1'>".$row[0]."</td><td class='tbl2'>".$row[1]."</td></tr>\n";
}
$result = dbarray(dbquery("SHOW TABLE STATUS LIKE '".$db_prefix."messages'"));
echo "<tr>\n<td colspan='2' class='tbl2'><b>Next Autoindex:</b> ".$result['Auto_increment']."</td>\n</tr>\n";
echo "</table>\n";
}
closetable();
?>
Category Forum
Bugs and Errors - 6Labels
None yet
Statistics
0 participants
Notifications
You are not receiving notifications from this thread.
Related Questions