Trying to alter template

[scotbuff]

I am trying to alter my template in a big way, sort of like this communities forum layout but matching my site.  I keep getting the following errors.  I am running a lot of php scripts to do various things, like a poll, user counter etc...  

2: Supplied argument is not a valid MySQL result resource
(/home/nitevil/public_html/forums/Sources/BoardIndex.php ln 154)

Does this error mean that line 154 of the BoardIndex.php is conflicting with something else I am running?  I was a bit confused by this error.  Thanks in advance.    

[ikkebra]

Not sure if this helps, but I once got this same error setting up phpNuke and it was due to a the database tables not being setup properly and I had to rerun the SQL statement to rebuild the database.

[Jeff Lewis]

if you could tell me the SQL query right before line 154 I might have an idea...

[scotbuff]

Sure, this is line 152

$result = mysql_query("SELECT name,ID_CAT FROM {$db_prefix}categories WHERE ('$settings[7]'='Administrator' || '$settings[7]'='Global Moderator' || FIND_IN_SET('$settings[7]',memberGroups)!=0 || memberGroups='') ORDER BY catOrder");

line 153 is blank and line 154 in the BoardIndex is this.

while ($row_cat = mysql_fetch_array($result))

I should of included that on my question, stupid me just thought everyones would be the same, forgot about possible mods etc.  

Any help would be greatly appreciated, I do not think I need to rebuild a table as suggested, because when restoring my original template the board works fine no error.  That is why I thought it must be interferring with another piece I have on my site.  I am new to PHP so this error is new to me.  Thanks in advance.  

[Hypocrite]

Try taking away the blank line in 153

[scotbuff]

Nope, that did not fix it, the same thing happens, the entire template layout appears but where the boards should appear is nothing but the previously described error.  Only now it refers to the line 152, which is the same blocks of code within the BoardIndex.php.

[Mach8]

After this line:

Code Select Expand

while ($row_cat = mysql_fetch_array($result))

Add this:

Code Select Expand

echo mysql_error();

And post here what it says...

[scotbuff]

Um, OK.  I tried the echo under the while statement first, I got nothing new back, just the same error.  Then I moved it directly under the MySQL query and I got the following:

No Database Selected

Along with the error

2: Supplied argument is not a valid MySQL result resource
(/home/nitevil/public_html/forums/Sources/BoardIndex.php ln 153)

Are my variables somehow getting unset for my board when I try to use this template?  Hmm..  Thanks for the suggestions so far guys.  I appreciate you trying to help.