chris
Guest
|
 |
Re:2: Supplied argument is not a valid Mysql result resource
« Reply #1 on: July 09, 2003, 12:35:14 PM » |
|
Da stimmt primär schonmal nicht, dass der Fehler bei V1.5.3 niemals auftreten können sollte (weil eigentlich IMMER eine Klartext-Fehlermeldung kommen müsste).
Poste mal die entsprechende Zeile (+ein paar davor und ein paar danach)
bei mir wäre das:
$result_boards = mysql_query (" SELECT DISTINCT c.name AS catName, c.ID_CAT, b.ID_BOARD, b.name AS boardName, b.description, b.moderators, b.numPosts, b.numTopics, c.memberGroups, m.posterName, m.posterTime, m.subject, t.ID_TOPIC, t.numReplies, IFNULL(mem.realName, m.posterName) AS realName, IFNULL(lb.logTime, 0) AS boardTime, IFNULL(lmr.logTime, 0) AS markReadTime, IFNULL(mem.ID_MEMBER, -1) AS ID_MEMBER FROM {$db_prefix}categories AS c LEFT JOIN {$db_prefix}boards AS b ON (b.ID_CAT=c.ID_CAT) LEFT JOIN {$db_prefix}topics AS t ON (t.ID_TOPIC=b.ID_LAST_TOPIC) LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG=t.ID_LAST_MSG) LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER=m.ID_MEMBER) LEFT JOIN {$db_prefix}log_boards AS lb ON (lb.ID_BOARD=b.ID_BOARD AND lb.ID_MEMBER=$ID_MEMBER) LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD=b.ID_BOARD AND lmr.ID_MEMBER=$ID_MEMBER) WHERE $condition ORDER BY c.catOrder, c.ID_CAT, b.boardOrder, b.ID_BOARD") or database_error(__FILE__, __LINE__);
$curcat = -1; while ($row_board = mysql_fetch_assoc($result_boards)) { // if this is a new category if ($row_board['ID_CAT'] != $curcat) { $curcat=$row_board['ID_CAT']; echo "<tr> <td colspan=\"5\" class=\"catbg\" height=\"18\">\n"; echo "<a name=\"$row_board[ID_CAT]\"><b>$row_board[catName]</b></a></td>\n</tr>\n";
wobei
while ($row_board = mysql_fetch_assoc($result_boards))
die Zeile ist wo es knallt... wenns bei Dir die gleiche ist, füg da mal
echo mysql_error();
vor ein... dann gibt er ne Info aus, was schief gelaufen ist...
|