Okay again I say. I rehacked even though your files have your updates and this is what I get my friend.
SQL ERROR: Unable to do_query: SELECT Bo_Title, Bo_Keyword FROM w3t_Boards WHERE Bo_Cat = 1 AND () ORDER BY Bo_Sorter
You have an error in your SQL syntax near ') ORDER BY Bo_Sorter ' at line 4SQL ERROR: Unable to do_query: SELECT Bo_Title, Bo_Keyword FROM w3t_Boards WHERE Bo_Cat = 2 AND () ORDER BY Bo_Sorter
You have an error in your SQL syntax near ') ORDER BY Bo_Sorter ' at line 4SQL ERROR: Unable to do_query: SELECT Bo_Title, Bo_Keyword FROM w3t_Boards WHERE Bo_Cat = 3 AND () ORDER BY Bo_Sorter
You have an error in your SQL syntax near ') ORDER BY Bo_Sorter ' at line 4SQL ERROR: Unable to do_query: SELECT Bo_Title, Bo_Keyword FROM w3t_Boards WHERE Bo_Cat = 4 AND () ORDER BY Bo_Sorter
You have an error in your SQL syntax near ') ORDER BY Bo_Sorter ' at line 4SQL ERROR: Unable to do_query: SELECT Bo_Title, Bo_Keyword FROM w3t_Boards WHERE Bo_Cat = 5 AND () ORDER BY Bo_Sorter
You have an error in your SQL syntax near ') ORDER BY Bo_Sorter ' at line 4SQL ERROR: Unable to do_query: SELECT Bo_Title, Bo_Keyword FROM w3t_Boards WHERE Bo_Cat = 6 AND () ORDER BY Bo_Sorter
You have an error in your SQL syntax near ') ORDER BY Bo_Sorter ' at line 4SQL ERROR: Unable to do_query: SELECT Bo_Title, Bo_Keyword FROM w3t_Boards WHERE Bo_Cat = 7 AND () ORDER BY Bo_Sorter
You have an error in your SQL syntax near ') ORDER BY Bo_Sorter ' at line 4SQL ERROR: Unable to do_query: SELECT Bo_Title, Bo_Keyword FROM w3t_Boards WHERE Bo_Cat = 8 AND () ORDER BY Bo_Sorter
You have an error in your SQL syntax near ') ORDER BY Bo_Sorter ' at line 4 Today's Active Topics
New Since Your Last Visit
ENTRANCE
News and Announcements
Obviously something different as either the code is a bit different on your site or we have another little problem.
Here is the section of code where you are inputing the AND ()
// ------------------------------------------------------------------- <br />// We need to format a SQL query to see what boards this user can view <br /> $Grouparray = split("-",$Groups); <br /> $gsize = sizeof($Grouparray); <br /> $groupquery = "AND ("; <br /> $g = 0; <br /> for ($i=0; $i<$gsize;$i++) { <br /> if (!preg_match("/[0-9]/",$Grouparray[$i])) { continue; }; <br /> $g++; <br /> if ($g > 1) { <br /> $groupquery .= " OR "; <br /> } <br /> $groupquery .= "Bo_Read_Perm LIKE '%-$Grouparray[$i]-%'"; <br /> } <br /> $groupquery .= ")"; <br /> <br /> $query = " <br /> SELECT Cat_Title, Cat_Number <br /> FROM {$config['tbprefix']}Category <br /> ORDER BY Cat_Number <br /> "; <br /> <br /> $allCats = $dbh -> do_query($query); <br /> $catMenu = " <br /> <table border=\"1\" class=\"tdheader\"> <br /> <tr> <br /> <td class=\"alterline\"><font size=\"1\"><a href=\"{$config['homeurl']}/index.php?Cat=\"><b>ENTRANCE</b></a></font></td> <br /> </tr> <br /> "; <br /> <br /> while (list($theCat, $theCatNum) = $dbh -> fetch_array($allCats)) { <br /> <br /> $query = " <br /> SELECT Bo_Title, Bo_Keyword <br /> FROM {$config['tbprefix']}Boards <br /> WHERE Bo_Cat = {$theCatNum} {$groupquery} <br /> ORDER BY Bo_Sorter <br /> ";