Twirp
10-23-2004, 05:13 PM
I'm trying to code a forum but the posts aren't showing up :/
here's the code:
</td></tr>
<tr><td colspan=5 class="tblhd">
<?php
$df = mysql_db_query($db,"SELECT * FROM mbforum WHERE id='$f'");
while($dsf=mysql_fetch_array($df)){
echo"<a href=\"index.php\">$brnm</a>~>$dsf[forum]";
}
?>
</td></tr>
<tr>
<td colspan=5>
<?php
if($user!=""){
if($skin==""){
echo"<a href=\"index.php?mode=new&f=$f&ty=new\"><img src=\"new.gif\" alt=\"New Post\" align=\"right\"></a>";
}else{
echo"<a href=\"index.php?mode=new&f=$f&ty=new\"><img src=\"$skin/new.gif\" alt=\"New Post\" align=\"right\"></a>";
}
}else{
echo"<a href=\"index.php?mode=login\"><img src=\"new.gif\" alt=\"Login\" align=\"right\"></a>";
}
?></td></tr>
<tr><td colspan=5 class="tblhd"><b>Sticky Important Posts</b></td></tr>
<?php
$ds = "SELECT * FROM mbposts WHERE forum='$f' AND type='stick' ORDER BY cid DESC";
$shtw = mysql_db_query($db,$ds);
while($dp=mysql_fetch_array($shtw)){
$topic = "$dp[topic]";
$check = strpos($dis,"$dp[id]");
if(!$check){
$dis.=" $dp[id] ";
$did = "SELECT * FROM mbposts WHERE id='$dp[id]' ORDER BY cid DESC LIMIT 1";
$shown = mysql_db_query($db,$did);
while($d2=mysql_fetch_array($shown)){
echo"<tr><td width=5%><center>";
$dispic = mysql_db_query($db,"SELECT * FROM mbread WHERE who='$user' AND topic='$topic' AND forum='$f'");
while($dpc=mysql_fetch_array($dispic)){
$new="no";
}
if($new=="no"){
if($skin==""){
echo"<img src=\"no.png\">";
}else{
echo"<img src=\"$skin=/no.png\">";
}
}else{
if($skin==""){
echo"<img src=\"new.png\">";
}else{
echo"<img src=\"$skin/new.png\">";
}
}
$topic = str_replace("\'","'",$d2[topic]);
$topic = str_replace("'","'",$topic);
echo"</center></td><td width=35%><a href=\"index.php?mode=topic&topic=$d2[id]&f=$f\">$topic</a></td>";
$dps = mysql_db_query($db,"SELECT * FROM mbposts WHERE forum='$f' AND id='$dr[id]'");
$dp = mysql_num_rows($dps);
if($dp<2){
$rr = $dp;
}else{
$rr = $dp-1;
}
echo"<td width=20%>Replies: $rr</td>";
echo"<td width=20%>Last: $d2[who]</td><td width=20%>On: $d2[date]</td></tr>";
}
}
}
?>
<tr><td colspan=5 class="tblhd"><b>Posts</b></td></tr>
<?php
$do = "SELECT topic FROM mbposts WHERE forum='$f' AND type!='stick' ORDER BY cid DESC ";
$show = mysql_db_query($db,$do);
$rows_per_page=20;
$total_records=mysql_num_rows($show);
$pages = ceil($total_records / $rows_per_page);
mysql_free_result($show);
if (!isset($screen))
$screen=0;
$start = $screen * $rows_per_page;
$do.="LIMIT $start, $rows_per_page";
$show = mysql_db_query($db,$do) or die ("Could not execute query : $q." . mysql_error());
echo"<tr><td colspan=5 class=\"tblhd\">";
if ($screen > 0) {
$j = $screen - 1;
$url = "index.php?mode=forum&screen=$j&f=$f";
echo "<a href=\"$url\"><<</a>";
}
// page numbering links now
for ($i = 0; $i < $pages; $i++) {
$url = "index.php?mode=forum&f=$f&screen=$i";
$j = $i + 1;
if($i==$screen){
echo"|$j|";
}else{
echo " | <a href=\"$url\">$j</a> | ";
}
}
if ($screen < $pages-1) {
$j = $screen + 1;
$url = "index.php?mode=forum&screen=$j&f=$f";
echo "<a href=\"$url\">>></a>";
}
echo"</td></tr>";
while($dr=mysql_fetch_array($show)){
$topic = "$dr[topic]";
$check = strrpos($dis,"$dr[id]");
if(!$check){
$dis.=" $dr[id] ";
$did = "SELECT * FROM mbposts WHERE id='$dr[id]' ORDER BY cid DESC LIMIT 1";
$shown = mysql_db_query($db,$did);
while($d2=mysql_fetch_array($shown)){
echo"<tr><td width=5%><center>";
$dispic = mysql_db_query($db,"SELECT * FROM mbread WHERE who='$user' AND id='$dr[id]' AND forum='$f'");
while($dpc=mysql_fetch_array($dispic)){
$new="no";
}
if($new=="no"){
if($skin==""){
echo"<img src=\"no.png\">";
}else{
echo"<img src=\"$skin=/no.png\">";
}
}else{
if($skin==""){
echo"<img src=\"new.png\">";
}else{
echo"<img src=\"$skin/new.png\">";
}
}
$topic = str_replace("\'","'",$d2[topic]);
$topic = str_replace("'","'",$topic);
echo"</center></td><td width=35%><a href=\"index.php?mode=topic&topic=$topic&f=$f\">$topic</a></td>";
$dps = mysql_db_query($db,"SELECT * FROM mbposts WHERE forum='$f' AND id='$dr[id]'");
$dp = mysql_num_rows($dps);
if($dp<2){
$rr = $dp;
}else{
$rr = $dp-1;
}
echo"<td width=20%>Replies: $rr</td>";
echo"<td width=20%>Last: $d2[who]</td><td width=20%>On: $d2[date]</td></tr>";
}
}
}
?>
<td>
thanks
here's the code:
</td></tr>
<tr><td colspan=5 class="tblhd">
<?php
$df = mysql_db_query($db,"SELECT * FROM mbforum WHERE id='$f'");
while($dsf=mysql_fetch_array($df)){
echo"<a href=\"index.php\">$brnm</a>~>$dsf[forum]";
}
?>
</td></tr>
<tr>
<td colspan=5>
<?php
if($user!=""){
if($skin==""){
echo"<a href=\"index.php?mode=new&f=$f&ty=new\"><img src=\"new.gif\" alt=\"New Post\" align=\"right\"></a>";
}else{
echo"<a href=\"index.php?mode=new&f=$f&ty=new\"><img src=\"$skin/new.gif\" alt=\"New Post\" align=\"right\"></a>";
}
}else{
echo"<a href=\"index.php?mode=login\"><img src=\"new.gif\" alt=\"Login\" align=\"right\"></a>";
}
?></td></tr>
<tr><td colspan=5 class="tblhd"><b>Sticky Important Posts</b></td></tr>
<?php
$ds = "SELECT * FROM mbposts WHERE forum='$f' AND type='stick' ORDER BY cid DESC";
$shtw = mysql_db_query($db,$ds);
while($dp=mysql_fetch_array($shtw)){
$topic = "$dp[topic]";
$check = strpos($dis,"$dp[id]");
if(!$check){
$dis.=" $dp[id] ";
$did = "SELECT * FROM mbposts WHERE id='$dp[id]' ORDER BY cid DESC LIMIT 1";
$shown = mysql_db_query($db,$did);
while($d2=mysql_fetch_array($shown)){
echo"<tr><td width=5%><center>";
$dispic = mysql_db_query($db,"SELECT * FROM mbread WHERE who='$user' AND topic='$topic' AND forum='$f'");
while($dpc=mysql_fetch_array($dispic)){
$new="no";
}
if($new=="no"){
if($skin==""){
echo"<img src=\"no.png\">";
}else{
echo"<img src=\"$skin=/no.png\">";
}
}else{
if($skin==""){
echo"<img src=\"new.png\">";
}else{
echo"<img src=\"$skin/new.png\">";
}
}
$topic = str_replace("\'","'",$d2[topic]);
$topic = str_replace("'","'",$topic);
echo"</center></td><td width=35%><a href=\"index.php?mode=topic&topic=$d2[id]&f=$f\">$topic</a></td>";
$dps = mysql_db_query($db,"SELECT * FROM mbposts WHERE forum='$f' AND id='$dr[id]'");
$dp = mysql_num_rows($dps);
if($dp<2){
$rr = $dp;
}else{
$rr = $dp-1;
}
echo"<td width=20%>Replies: $rr</td>";
echo"<td width=20%>Last: $d2[who]</td><td width=20%>On: $d2[date]</td></tr>";
}
}
}
?>
<tr><td colspan=5 class="tblhd"><b>Posts</b></td></tr>
<?php
$do = "SELECT topic FROM mbposts WHERE forum='$f' AND type!='stick' ORDER BY cid DESC ";
$show = mysql_db_query($db,$do);
$rows_per_page=20;
$total_records=mysql_num_rows($show);
$pages = ceil($total_records / $rows_per_page);
mysql_free_result($show);
if (!isset($screen))
$screen=0;
$start = $screen * $rows_per_page;
$do.="LIMIT $start, $rows_per_page";
$show = mysql_db_query($db,$do) or die ("Could not execute query : $q." . mysql_error());
echo"<tr><td colspan=5 class=\"tblhd\">";
if ($screen > 0) {
$j = $screen - 1;
$url = "index.php?mode=forum&screen=$j&f=$f";
echo "<a href=\"$url\"><<</a>";
}
// page numbering links now
for ($i = 0; $i < $pages; $i++) {
$url = "index.php?mode=forum&f=$f&screen=$i";
$j = $i + 1;
if($i==$screen){
echo"|$j|";
}else{
echo " | <a href=\"$url\">$j</a> | ";
}
}
if ($screen < $pages-1) {
$j = $screen + 1;
$url = "index.php?mode=forum&screen=$j&f=$f";
echo "<a href=\"$url\">>></a>";
}
echo"</td></tr>";
while($dr=mysql_fetch_array($show)){
$topic = "$dr[topic]";
$check = strrpos($dis,"$dr[id]");
if(!$check){
$dis.=" $dr[id] ";
$did = "SELECT * FROM mbposts WHERE id='$dr[id]' ORDER BY cid DESC LIMIT 1";
$shown = mysql_db_query($db,$did);
while($d2=mysql_fetch_array($shown)){
echo"<tr><td width=5%><center>";
$dispic = mysql_db_query($db,"SELECT * FROM mbread WHERE who='$user' AND id='$dr[id]' AND forum='$f'");
while($dpc=mysql_fetch_array($dispic)){
$new="no";
}
if($new=="no"){
if($skin==""){
echo"<img src=\"no.png\">";
}else{
echo"<img src=\"$skin=/no.png\">";
}
}else{
if($skin==""){
echo"<img src=\"new.png\">";
}else{
echo"<img src=\"$skin/new.png\">";
}
}
$topic = str_replace("\'","'",$d2[topic]);
$topic = str_replace("'","'",$topic);
echo"</center></td><td width=35%><a href=\"index.php?mode=topic&topic=$topic&f=$f\">$topic</a></td>";
$dps = mysql_db_query($db,"SELECT * FROM mbposts WHERE forum='$f' AND id='$dr[id]'");
$dp = mysql_num_rows($dps);
if($dp<2){
$rr = $dp;
}else{
$rr = $dp-1;
}
echo"<td width=20%>Replies: $rr</td>";
echo"<td width=20%>Last: $d2[who]</td><td width=20%>On: $d2[date]</td></tr>";
}
}
}
?>
<td>
thanks