<?php
opentable("Table Structure");
$result = mysql_query("SHOW COLUMNS FROM {$db_prefix}news");
if (mysql_num_rows($result) > 0) {
echo "<table cellspacing='1' cellpadding='0' class='tbl-border'>\n<td colspan='2' class='tbl2'><b>News 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."news'"));
echo "<tr>\n<td colspan='2' class='tbl2'><b>Next Autoindex:</b> ".$result['Auto_increment']."</td>\n</tr>\n";
echo "</table>\n";
}
closetable();
?>
Quote
chbe wrote:
There is no value to Next Autoindex:
Do you have the news_id set to autoincrement?
You can se this through phpMyAdmin.
fusion_news
CHANGE news_id
news_id
SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT '0' AUTO_INCREMENTALTER TABLE fusion_news
CHANGE news_id
news_id
SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT
Category Forum
Official Core Support - 6Labels
None yet
Statistics
0 participants
Notifications
You are not receiving notifications from this thread.
Related Questions