With this script that I asked for about 3-5 months back

PHP Code:

$i = 0;
$latest = '';
$postsQ = '';
$threads = mysql_query("SELECT * FROM threads WHERE board='".$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 cDate DESC");  

while ($row2A = mysql_fetch_array($posts)){
    if ($i == 0){
        $latest = format_date($row2A['cDate']).'<br />by ' . returnUsername($row2A['creator']);
    }
    $i++;
} 


When nothing is in the DB for "posts" then it does a Warning, is there anyway other then to shut off PHP warnings to get it to stop.

"It does a warning" is somewhat vague for debugging.

We may just need to know what the warning is.

@ will suppress any error messages from a particular line of code.

PHP Code:

$posts = @mysql_query("SELECT * FROM posts WHERE thread in ($list) ORDER BY cDate DESC");

if(!$posts || @mysql_num_rows($posts) < 1)
{
     //display no posts message
}
else
{
     while ($row2A = mysql_fetch_array($posts)){
         if ($i == 0){
             $latest = format_date($row2A['cDate']).'<br />by ' . returnUsername($row2A['creator']);
         }
         $i++;
     }
} 


Works for me, thanks nullpointer

Originally Posted by Aaron™

Works for me, thanks nullpointer

No problem. Make sure you use it sparingly, error and warning messages are there to help you.