this dont show 3 shouts why ??

[nclemale36]

function getshoutbox($sid)
{
   $shbox .= "<form action=\"genproc.php?action=shout&amp;sid=$sid\" method=\"post\"><center>";
  $shbox .= "<b></b>";
  $lshout = mysql_fetch_array(mysql_query("SELECT shout, shouter, id FROM ibwf_shouts ORDER BY shtime DESC LIMIT 3"));
  $shnick = getnick_uid($lshout[1]);
  $shbox .= "<i><a href=\"index.php?action=viewuser&amp;sid=$sid&amp;who=$lshout[1]\">".$shnick."</a></i> - ";
  $text = parsepm($lshout[0], $sid);
  $shbox .= $text;
  $shbox .= "<br/>";
  $shbox .= "<a href=\"lists.php?action=shouts&amp;sid=$sid\">more</a>";
  if (ismod(getuid_sid($sid)))
  {
  $shbox .= " <a href=\"modproc.php?action=delsh&amp;sid=$sid&amp;shid=$lshout[2]\">delete</a>";
  }
  if(getplusses(getuid_sid($sid))<75)
  {
  $shbox .= "<br/>You need at least 75 plusses to shout!";
  }else{
  $shbox .= "<br/>ShoutBox Message:<br/><input name=\"shtxt\" maxlength=\"100\"/><br/>";
  $shbox .= "<input type=\"Submit\" name=\"shout\" Value=\"Add Shout\"></center></form>";
  }
  return $shbox;
}

anyone help

[something else]

Because you havent looped your results:

function getshoutbox($sid)
{
   $shbox .= "<form action=\"genproc.php?action=shout&amp;sid=$sid\" method=\"post\"><center>";
  $shbox .= "<b></b>";
while($lshout=mysql_fetch_array(mysql_query("SELECT shout, shouter, id FROM ibwf_shouts ORDER BY shtime DESC LIMIT 3"))){
$shnick = getnick_uid($lshout[1]);
  $shbox .= "<i><a href=\"index.php?action=viewuser&amp;sid=$sid&amp;who=$lshout[1]\">".$shnick."</a></i> - ";
  $text = parsepm($lshout[0], $sid);
  $shbox .= $text;
  $shbox .= "<br/>";
}
 $shbox .= "<a href=\"lists.php?action=shouts&amp;sid=$sid\">more</a>";
  if (ismod(getuid_sid($sid)))
  {
  $shbox .= " <a href=\"modproc.php?action=delsh&amp;sid=$sid&amp;shid=$lshout[2]\">delete</a>";
  }
  if(getplusses(getuid_sid($sid))<75)
  {
  $shbox .= "<br/>You need at least 75 plusses to shout!";
  }else{
  $shbox .= "<br/>ShoutBox Message:<br/><input name=\"shtxt\" maxlength=\"100\"/><br/>";
  $shbox .= "<input type=\"Submit\" name=\"shout\" Value=\"Add Shout\"></center></form>";
  }
  return $shbox;
} 

[nclemale36]

wont load the main page now .

Added after 11 minutes:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/public_html/web/core.php on line 3204

which is my bbcode function. .

ignore above its any line that incorperates the shoutbox . wont load fullstop

[something else]

oops infintive loop lol

function getshoutbox($sid) 
{ 
   $shbox .= "<form action=\"genproc.php?action=shout&amp;sid=$sid\" method=\"post\"><center>"; 
  $shbox .= "<b></b>"; 
$data = mysql_query("SELECT shout, shouter, id FROM ibwf_shouts ORDER BY shtime DESC LIMIT 3");
while($lshout=mysql_fetch_array($data)){ 
$shnick = getnick_uid($lshout[1]); 
  $shbox .= "<i><a href=\"index.php?action=viewuser&amp;sid=$sid&amp;who=$lshout[1]\">".$shnick."</a></i> - "; 
  $text = parsepm($lshout[0], $sid); 
  $shbox .= $text; 
  $shbox .= "<br/>"; 
} 
 $shbox .= "<a href=\"lists.php?action=shouts&amp;sid=$sid\">more</a>"; 
  if (ismod(getuid_sid($sid))) 
  { 
  $shbox .= " <a href=\"modproc.php?action=delsh&amp;sid=$sid&amp;shid=$lshout[2]\">delete</a>"; 
  } 
  if(getplusses(getuid_sid($sid))<75) 
  { 
  $shbox .= "<br/>You need at least 75 plusses to shout!"; 
  }else{ 
  $shbox .= "<br/>ShoutBox Message:<br/><input name=\"shtxt\" maxlength=\"100\"/><br/>"; 
  $shbox .= "<input type=\"Submit\" name=\"shout\" Value=\"Add Shout\"></center></form>"; 
  } 
  return $shbox; 
} 

[nclemale36]

cheers mate but one small prob the delete shout dont work and which one would it delete if it did ?

[Vayne]

shoud be working

$data = mysql_query("SELECT shout, shouter, id FROM ibwf_shouts ORDER BY shtime DESC LIMIT 3"); 
while($lshout=mysql_fetch_array($data)){ 

 
  $shbox .= " <a href=\"modproc.php?action=delsh&amp;sid=$sid&amp;shid=$lshout[2]\">delete</a>"; 

[something else]

yeah the:
$shbox .= " <a href=\"modproc.php?action=delsh&amp;sid=$sid&amp;s hid=$lshout[2]\">delete</a>";
need putting inside the while($lshout=mysql_fetch_array($data)){
so it knows which shout to delete otherwize you will be only deleting last shout