Nukemods Forum - View Single Post

Mighty_Y · 02-11-2005, 05:42 AM

open theme.php and find

Code:

    $numrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_banner WHERE type='0' AND active='1'"));

replace with

Code:

    $sql = "SELECT * FROM ".$prefix."_banner WHERE type='0' AND active='1'";
		if( !$query = $db->sql_query($sql) )
		{
			die('Could not obtain banner information', '', __LINE__, __FILE__, $sql);
		}    
   $numrows = $db->sql_numrows($query);

And then report back

	(#5 (permalink))
Mighty_Y Moderator Status: Offline Posts: 957 Join Date: Nov 2002 Location: Belgium	02-11-2005, 05:42 AM open theme.php and find Code: $numrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_banner WHERE type='0' AND active='1'")); replace with Code: $sql = "SELECT * FROM ".$prefix."_banner WHERE type='0' AND active='1'"; if( !$query = $db->sql_query($sql) ) { die('Could not obtain banner information', '', __LINE__, __FILE__, $sql); } $numrows = $db->sql_numrows($query); And then report back Yannick R. aka Mighty_Y http://support.code-area51.com http://www.code-area51.com Search before asking makes my life easier!