PhpDig.net - View Single Post

Charter · 12-14-2004, 12:57 PM

Do "SHOW COLUMNS FROM table_name" and compare with the init_db.sql file. Make sure the prefix is set correctly in the connect.php file. Otherwise, in admin/index.php add:

PHP Code:


			
if (!$result) {

    echo "The error: ".mysql_error()."<br />\n";

}

After the following line:

PHP Code:


			
$result = mysql_fetch_array(mysql_query("SELECT count(*) as num FROM ".PHPDIG_DB_PREFIX."$table"),MYSQL_ASSOC);

And see what it prints onscreen.

12-14-2004, 12:57 PM	#9
Charter Head Mole Join Date: May 2003 Posts: 2,539	Do "SHOW COLUMNS FROM table_name" and compare with the init_db.sql file. Make sure the prefix is set correctly in the connect.php file. Otherwise, in admin/index.php add: PHP Code: `if (!$result) { echo "The error: ".mysql_error()."<br />\n"; }` After the following line: PHP Code: `$result = mysql_fetch_array(mysql_query("SELECT count(*) as num FROM ".PHPDIG_DB_PREFIX."$table"),MYSQL_ASSOC);` And see what it prints onscreen. __________________ Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.