Quote
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,15' at line 1You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,15' at line 1
<?php
$result = mysql_query("SHOW COLUMNS FROM {$db_prefix}download_cats");
if (mysql_num_rows($result) > 0) {
echo "<table class='tbl-border'>\n<td colspan='2'><b>download_cats 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";
}
echo "</table><br>\n";
}
$result = mysql_query("SHOW COLUMNS FROM {$db_prefix}weblink_cats");
if (mysql_num_rows($result) > 0) {
echo "<table class='tbl-border'>\n<td colspan='2'><b>weblink_cats 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";
}
echo "</table><br>\n";
}
?>
Quote
download_cats Table Scheme
download_cat_id smallint(5) unsigned
download_cat_name varchar(100)
download_cat_description text
download_cat_access tinyint(3) unsigned
download_parent tinyint(3)
weblink_cats Table Scheme
weblink_cat_id smallint(5) unsigned
weblink_cat_name varchar(100)
weblink_cat_description text
weblink_cat_sorting varchar(50)
weblink_cat_access tinyint(3) unsigned
<?php
$res = dbquery("alter table {$db_prefix}downloads_cats drop download_parent");
echo "Done";
?>
Quote
Table 'mucus.fusion_downloads_cats' doesn't existDone
<?php
$res = dbquery("alter table {$db_prefix}download_cats drop download_parent");
echo "Done";
?>
<?php
$result = dbquery("ALTER TABLE ".$db_prefix."download_cats ADD download_cat_sorting VARCHAR(50) DEFAULT 'download_title ASC' NOT NULL AFTER download_cat_description");
echo "download_cat_sorting fixed";
?>
Quote
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,15' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,15' at line 1
Category Forum
Bugs and Errors - 6Labels
None yet
Statistics
0 participants
Notifications
You are not receiving notifications from this thread.
Related Questions