My warning is "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/zybersca/public_html/code-bin/themes/hd/_index.php on line 211"

and ive worked it out so i can get it not error but it then wont do what i need it to.

PHP Code:

<?php
$i = 0;
$latest = '';
$postsQ = '';
$threads = mysql_query("SELECT * FROM threads WHERE forum={$row2['id']}");
  while ($thread = mysql_fetch_array($threads)) {
    if ($postsQ != '') {
        $postsQ .= ' OR ';
    }
    $postsQ .= 'thread= '.$thread['id'];
}
  
$posts = mysql_query("SELECT * FROM posts WHERE $postsQ ORDER BY createdYear DESC, createdMonth DESC, createdDate DESC, createdHour DESC, createdMinute DESC, createdSecond DESC");
while ($row2A = mysql_fetch_array($posts)) {
    if ($i == 0) {
        $latest = compileTimestamp($row2A['createdMonth'], $row2A['createdDate'], $row2A['createdYear'], $row2A['createdHour'], $row2A['createdMinute'], $row2A['createdSecond']) . '<br />by ' . returnUsername($row2A['creator']);
    }
    $i++;
}
?>

see what error it is, and echo the actual SQL statement so you can read it:

PHP Code:

$sql = "SELECT * FROM threads WHERE forum={$row2['id']}"
$threads = mysql_query($sql) or die(mysql_error().": ".$sql); 


This is just a debugging line, and I don't recommend you plant stuff like this during production.

PHP Code:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY createdYear DESC, createdMonth DESC, createdDate DESC, createdHour DESC' at line 1 


Check the syntax of the fields, the error may be there.
To simplify your query, you don't have to specify the direction on each order by elements, you could write it

SELECT * 
FROM posts 
WHERE $postsQ 
ORDER BY createdYear, createdMonth, createdDate, createdHour, createdMinute, createdSecond DESC

Well I will take a lowly educated guess and would say it could be here because thats whats getting echo'ed into the sql syntax

PHP Code:

while ($thread = mysql_fetch_array($threads)){
    if ($postsQ != ''){
        $postsQ .= ' OR ';
    }
    $postsQ .= 'thread='.$thread['id'];
} 


Anyone?

is this valid?...

PHP Code:

"SELECT * FROM threads WHERE forum={$row2['id']}" 


try this...

PHP Code:

 
$forumVal = $row2['id'];
 
$sql = "SELECT * FROM threads WHERE forum='$forumVal'"; 


Still has the same error. I really think its in the $postsQ but I don't know what would be wrong.

ok

start debugging

first echo the $sql variable out to see if the SQL Syntax is valid

I echo'ed $postsQ and I get this

thread= 112 OR thread= 94thread= 91

But I get something similar to that on another category with no errors.

thread= 92 OR thread= 93thread= 3

that is not valid SQL

echo the sql variable and see if its valid

Your example is invalid.....

 thread= 112 OR thread= 94thread= 91

this should be

 thread= '112' OR thread= '94' OR thread= '91'

So what one do you want me to echo there is 2.... $posts or $threads

did you write this or did you copy and paste it?

i ask so i know that you will be able to spot a mistake if you can debug it?

Be honest so we can sort this out

Were the hell would I copy and paste code for a post counter and a last post viewer, but yes I did, I had a friend whom I dont talk to anymore do this part of the code.

Originally Posted by Aaron™

Where the hell would I ..... but yes I did...

lmao

Aren't you a great mod.

Originally Posted by Aaron™

Aren't you a great mod.

Can you blame him? Honestly when I read your reply I thought of Rick James.

Change:

PHP Code:

$postsQ .= 'thread= '.$thread['id']; 


To:

PHP Code:

$postsQ .= 'thread = \''.$thread['id'].'\' '; 


That should fix the problem with the spaces.

Still doesn't fix the error tho.
I've un-hid the category for you to see. The error and to see the $postsQ;
http://zyberscape.com/
For the source of _index.php
http://zyberscape.com/index.phps

PHP Code:

while ($thread = mysql_fetch_array($threads)){
    if ($postsQ != ""){
        $postsQ .= " OR ";
        $poststhreadid .= 'thread = \''.$thread['id'].'\' ';
    }else{
    $postsQ .= ''; //removes OR from SQL
    }
      
}
  
$posts = mysql_query("SELECT * FROM posts WHERE '".$poststhreadid."' '".$postsQ."' ORDER BY createdYear DESC, createdMonth DESC, createdDate DESC, createdHour DESC, createdMinute DESC, createdSecond DESC"); 


Maybe if you try to simplify your query:

SELECT * FROM threads WHERE forum in (1,2,3,102,103,14)

No need to add OR and such.

PHP Code:

$threads = mysql_query("SELECT * FROM threads WHERE forum={$row2['id']} ORDER BY id ASC");
$list="";
while ($thread = mysql_fetch_array($threads)){
    if($list!=''){
        $list.=",";
    }
    $list.=$thread['id']; 
}
  
$posts = mysql_query("SELECT * FROM posts WHERE thread in ($list) ORDER BY createdYear DESC, createdMonth DESC, createdDate DESC, createdHour DESC, createdMinute DESC, createdSecond DESC");