[Jenta]

sorry, for some reason after some frustration i forgot i was posting php code
thought it was sql and code would be better suited, i will edit it now

i got an error with one of ur queries, not sure why as i went and looked up min and max and it looks good
but it returned this...

PHP Code:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT MIN(shoutid) AS min, SELECT MAX(shoutid) AS max FROM shoutbox_posts 


so i went and took a shot and tried whats below
it works but not sure its the best way to do it

i trust you more than my guesses
if this is good enough, thanks a lot for your help

you seem to be one of the few around here offering any help
i really appreciate it

if you have anything to add, im all ears

thanks again!

PHP Code:

$shoutboxmax = mysql_query('SELECT shoutid from shoutbox_posts');
$num_rows = mysql_num_rows($shoutboxmax);
$firstshoutid = $DB_site->query_first("SELECT MIN(shoutid) AS min 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 > (($num_rows + $firstshoutid[min]) - $vboptions[shoutbox_numberofforumhomeshouts])
            ORDER BY shoutid ASC
            ");