[Jenta]

marco's query is fine but no matter what i tried i get stuff like this...

PHP Code:

Database error in vBulletin 3.0.7:
Invalid SQL:  
SELECT s.*, u.username AS absusername 
FROM shoutbox_posts AS s 
LEFT JOIN user AS u ON (s.userid = u.userid) 
WHERE (deleted = 0 OR deleted IS NULL) 
AND shoutid > (( + shoutbox_num[min]) - 20) 
ORDER BY shoutid ASC 
                            
for the right syntax to use near '+ shoutbox_num[min]) - 20) 
ORDER BY shoutid ASC' at line 5 


tried some crazy guesses and all returned an error...

PHP Code:

AND shoutid > (($shoutbox_num[max] + shoutbox_num[min]) - $vboptions[shoutbox_numberofforumhomeshouts]) 


PHP Code:

AND shoutid > (($shoutbox_num[max] + $shoutbox_num[min]) - $vboptions[shoutbox_numberofforumhomeshouts]) 


PHP Code:

AND shoutid > ((shoutbox_num[max] + shoutbox_num[min]) - $vboptions[shoutbox_numberofforumhomeshouts]) 


PHP Code:

AND shoutid > (($shoutbox_num[max]) + ($shoutbox_num[min])) - $vboptions[shoutbox_numberofforumhomeshouts]) 


thanks guys!


------------------------------------------------------------------------------
heh, i know why after looking at it
that calculation my friend originally had makes no sense
u dont need the first shoutid
all u need is the last shoutid, subtract shoutbox_numberofforumhomeshouts and ur done

you get the last X amount dispayed

thanks again!

PHP Code:

$lastshoutid = $DB_site->query_first("SELECT MAX(shoutid) AS max FROM shoutbox_posts"); 
$shoutbox_posts = $DB_site->query(" 
            SELECT s.*, u.username AS absusername 
            FROM shoutbox_posts s 
            LEFT JOIN user u ON (s.userid=u.userid) 
            WHERE (deleted='0' OR deleted IS NULL) 
            AND shoutid > ($lastshoutid[max] - $vboptions[shoutbox_numberofforumhomeshouts]) 
            ORDER BY shoutid ASC 
            ");