Weet iemand een voorbeeld script voor comments?

Status
Niet open voor verdere reacties.
ik heb het script even aan gepast zodat die automatisch ziet op welke pagina die zit.

PHP:
<?php 
///////////////// eerst contact maken met de database //////////////////////
 $db = "mijn_database";
$dbuser = "user";
$dbpass = "pass";
$dbhost = "localhost";
$dbh=mysql_connect("$dbhost","$dbuser","$dbpass");
mysql_select_db( "$db" ) or trigger_error( mysql_error() );
//////////////// contact gemaakt met de database /////////////////
$page=$_SERVER['PHP_SELF'];
$article=$_GET['article'];
if($_GET['soort']=='reply'){
//////////////// een pagina voor het maken van de comments ////////////
$reply=$_GET['reply'];
	$article_id=$_GET['article_id'];

		echo "<center><h3>Comment</h3>";
	
		echo "<table width=85% border=0><form method='POST' action='$page?article_id=$article_id&soort=post'>";
		
		echo "<input type='hidden' name='article_id' value='$article_id'>";		
			echo "<tr align='center'><td>Post<td><TEXTAREA name='post_text' cols='60' rows='6'></TEXTAREA>";
		echo "<tr align='center'><td><td><input type='submit' name='post' value='Post'><input type='hidden' name='post' value='post'></form>";
		echo "</table>";
//////////////// einde pagina voor het maken van de comments ////////////	
}else{
//////////////// een pagina voor het laten zien van de comments ////////////

//////////////// eerst een klein stukje voor het posten /////////////

if($_GET['soort']='post' and $_POST['post']='post' and $_POST['post_text']!=''){
	
	$article_id=$_POST['article_id'];
	$post_text=$_POST['post_text'];
	$time=time();
$Query_post_in_forum="INSERT INTO `comments` (`ID`, `article_id`, `poster`, `post`, `time`) VALUES ('','$article_id','".$_SESSION['user_id']."', '$post_text', '$time')";
	$res_post_in_forum=mysql_query($Query_post_in_forum);
$fout=mysql_errno($dbh);
    if ($fout != 0) {
    $fout=mysql_error($dbh);
    echo "<font color=\#FF0000\"><center>An error occured. This is the error message:$fout. Error code: 1 <br> Sorry for the inconvenience.<br><br>The taridge admin team.</center></font>";
    mysql_close($dbh);
    echo "</body></html>";
    exit;
}
}
////////////// einde posten, nu de pagina /////////////
$article_id=$_GET['article_id'];
$query_select_post="SELECT * FROM `comments` where `article_id`='$article_id'";
$res_select_post=mysql_query($query_select_post);
$fout=mysql_errno($dbh);
    if ($fout != 0) {
    $fout=mysql_error($dbh);
    echo "<font color=\#FF0000\"><center>An error occured. This is the error message:$fout. <br> Sorry for the inconvenience.<br><br>The taridge admin team.</center></font>";
    mysql_close($dbh);
    echo "</body></html>";
    exit;
}

$aantal_posts_made=mysql_num_rows($res_select_post);
//$aantal_posts_made=3;
if($aantal_posts_made!=0){
	echo "<table>";
for($tellingnummer_post=0;$tellingnummer_post<$aantal_posts_made;$tellingnummer_post++){
$row_select_posts=mysql_fetch_assoc($res_select_post);

$poster=$row_select_posts['poster'];
if($poster==''){
	$poster='Anonymous';
}
$post=$row_select_posts['post'];

	echo "<tr align='center'><td width=22% style='border: 1px solid #C0C0C0;'>Poster: $poster<td style='border: 1px solid #C0C0C0;'>$post";	
}
echo "</table>";

}else{
echo "No post found.";	
}
echo "<br><a href='$page?article_id=$article_id&soort=reply'>Reply</a>";
}
////////////////// einde van pagina voor het laten zien van de comments ///////////
?>

maar zoals jij het wil hebben (volgens mij) kan het ook. Dat moet zo:

PHP:
<?php */
///////////////// eerst contact maken met de database //////////////////////
 $db = "mijn_database";
$dbuser = "user";
$dbpass = "pass";
$dbhost = "localhost";
$dbh=mysql_connect("$dbhost","$dbuser","$dbpass");
mysql_select_db( "$db" ) or trigger_error( mysql_error() );
//////////////// contact gemaakt met de database /////////////////
$page=$_SERVER['PHP_SELF'];
$article=$_GET['article'];
if($_GET['soort']=='reply'){
//////////////// een pagina voor het maken van de comments ////////////
$reply=$_GET['reply'];
	$article_id=$_GET['article_id'];

		echo "<center><h3>Comment</h3>";
	
		echo "<table width=85% border=0><form method='POST' action='$page?article_id=$article_id&soort=post'>";
		
		echo "<input type='hidden' name='article_id' value='$article_id'>";		
			echo "<tr align='center'><td>Post<td><TEXTAREA name='post_text' cols='60' rows='6'></TEXTAREA>";
		echo "<tr align='center'><td><td><input type='submit' name='post' value='Post'><input type='hidden' name='post' value='post'></form>";
		echo "</table>";
//////////////// einde pagina voor het maken van de comments ////////////	
}else{
//////////////// een pagina voor het laten zien van de comments ////////////

//////////////// eerst een klein stukje voor het posten /////////////

if($_GET['soort']='post' and $_POST['post']='post' and $_POST['post_text']!=''){
	
	$article_id=$_POST['article_id'];
	$post_text=$_POST['post_text'];
	$time=time();
$Query_post_in_forum="INSERT INTO `comments` (`ID`, `article_id`, `poster`, `post`, `time`) VALUES ('','$article_id','".$_SESSION['user_id']."', '$post_text', '$time')";
	$res_post_in_forum=mysql_query($Query_post_in_forum);
$fout=mysql_errno($dbh);
    if ($fout != 0) {
    $fout=mysql_error($dbh);
    echo "<font color=\#FF0000\"><center>An error occured. This is the error message:$fout. Error code: 1 <br> Sorry for the inconvenience.<br><br>The taridge admin team.</center></font>";
    mysql_close($dbh);
    echo "</body></html>";
    exit;
}
}
////////////// einde posten, nu de pagina /////////////
$article_id=$_GET['article_id'];
$query_select_post="SELECT * FROM `comments` where `article_id`='$article_id'";
$res_select_post=mysql_query($query_select_post);
$fout=mysql_errno($dbh);
    if ($fout != 0) {
    $fout=mysql_error($dbh);
    echo "<font color=\#FF0000\"><center>An error occured. This is the error message:$fout. <br> Sorry for the inconvenience.<br><br>The taridge admin team.</center></font>";
    mysql_close($dbh);
    echo "</body></html>";
    exit;
}

$aantal_posts_made=mysql_num_rows($res_select_post);
//$aantal_posts_made=3;
if($aantal_posts_made!=0){
	echo "<table>";
for($tellingnummer_post=0;$tellingnummer_post<$aantal_posts_made;$tellingnummer_post++){
$row_select_posts=mysql_fetch_assoc($res_select_post);

$poster=$row_select_posts['poster'];
if($poster==''){
	$poster='Anonymous';
}
$post=$row_select_posts['post'];

	echo "<tr align='center'><td width=22% style='border: 1px solid #C0C0C0;'>Poster: $poster<td style='border: 1px solid #C0C0C0;'>$post";	
}
echo "</table>";

}else{
echo "No post found.";	
}

}
echo "<center><h3>Comment</h3>";
	
		echo "<table width=85% border=0><form method='POST' action='$page?article_id=$article_id&soort=post'>";
		
		echo "<input type='hidden' name='article_id' value='$article_id'>";		
			echo "<tr align='center'><td>Post<td><TEXTAREA name='post_text' cols='60' rows='6'></TEXTAREA>";
		echo "<tr align='center'><td><td><input type='submit' name='post' value='Post'><input type='hidden' name='post' value='post'></form>";
		echo "</table>";
////////////////// einde van pagina voor het laten zien van de comments ///////////
?>

om bij de hele pagina terug te komen:

PHP:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> 

<head> 
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 
    <meta name="Minizise" content="All about music producer Phonic AKA Minizise" /> 
    <meta name="Minizise" content="phonic,minizise,drumm n bass,minimal" /> 
    <meta name="Minizise" content="music, producer, minimal, house, drum 'n bass, lounge" /> 
     
    <title>MiniZise.NL | Portfolio Comments_test</title> 

<!-- CSS scripts --> 

    <link rel="shortcut icon"                                 href="favicon.ico" />        
    <link rel="stylesheet"         type="text/css"             href="css/style.css"         media="screen" /> 
       
<!-- Smooth scripts --> 
    <script type="text/javascript" src="Scripts/js/smooth.pack.js"></script>         
<!-- Accordian scripts -->  
    <link rel="stylesheet"         type="text/css"            href="css/accordeon.css"         media="screen" />    
    <script type="text/javascript" src="Scripts/js/accordian.pack.js"></script> 
<!-- Lightbox scripts --> 
    <link rel="stylesheet"         type="text/css"             href="css/lightbox.css"        media="screen" />  
    <script type="text/javascript" src="Scripts/js/prototype.js"></script> 
    <script type="text/javascript" src="Scripts/js/scriptaculous.js?load=effects"></script> 
    <script type="text/javascript" src="Scripts/js/lightbox.js"></script> 
    <script type="text/javascript" src="Scripts/js/scriptaculous.js"></script> 
<!-- Lightwindow scripts --> 
    <link rel="stylesheet"         type="text/css"     href="css/lightwindow.css" />  
    <script type="text/javascript" src="Scripts/javascript/prototype.js"></script> 
    <script type="text/javascript" src="Scripts/javascript/effects.js"></script> 
    <script type="text/javascript" src="Scripts/javascript/lightwindow.js"></script> 
    <script type="text/javascript" src="Scripts/javascript/scriptaculous.js?load=effects"></script> 
<!-- Main scripts --> 
    <script type="text/javascript" src="Scripts/rel.js"></script> 
    <script type="text/javascript" src="Scripts/AC_ActiveX.js"></script> 
    <script type="text/javascript" src="Scripts/AC_RunActiveContent.js"></script> 
    <script type="text/javascript" src="Scripts/swfobject.js"></script> 
     
         
    <style type="text/css"> 
.stijl3 {color: #CCCCCC} 
.stijl4 { 
    color: #FFFFFF; 
    font-style: italic; 
} 
body,td,th { 
    font-size: 9px; 
    color: #666666; 
} 
a:visited { 
    color: #93B300; 
} 
a:hover { 
    color: #93B300; 
} 
a:active { 
    color: #93B300; 
} 
body { 
    background-color: #FFFFFF; 
    background-image: url(images/headerstripe_loop.jpg); 
} 
.stijl7 {color: #FFFFFF} 
.stijl8 {font-size: 9px} 
.stijl9 {font-style: italic} 
.stijl10 { 
    color: #000000; 
    font-style: italic; 
} 
.style2 { 
    color: #93B300; 
    font-family: Verdana, Arial, Helvetica, sans-serif; 
} 
#apDiv2 { 
    position:absolute; 
    width:154px; 
    height:32px; 
    z-index:1; 
    left: 1px; 
    top: 95px; 
} 
#apDiv1 { 
    position:absolute; 
    width:84px; 
    height:93px; 
    z-index:2; 
    left: 1px; 
    top: 1606px; 
} 
.style3 {font-family: "Lithos Pro Regular"} 
.style4 {font-family: Verdana, Arial, Helvetica, sans-serif} 
.style5 {color: #333333; font-family: Verdana, Arial, Helvetica, sans-serif; } 

#apDiv3 { 
    position:absolute; 
    width:29px; 
    height:57px; 
    z-index:2; 
    right: 20px; 
    top: 1511px; 
} 
.style7 {color: #ECE9D8} 
#apDiv { 
    position:absolute; 
    width:29px; 
    height:57px; 
    z-index:2; 
    right: 9px; 
    top: 1239px; 
} 
.style9 {color: #666666} 
--> 
    </style> 

<script> 
nereidFadeObjects = new Object(); 
nereidFadeTimers = new Object(); 
function nereidFade(object, destOp, rate, delta){ 
if (!document.all) 
return 
    if (object != "[object]"){   
        setTimeout("nereidFade("+object+","+destOp+","+rate+","+delta+")",0); 
        return;    }         
    clearTimeout(nereidFadeTimers[object.sourceIndex]); 
        diff = destOp-object.filters.alpha.opacity; 
    direction = 1;    if (object.filters.alpha.opacity > destOp){ 
        direction = -1;    } 
    delta=Math.min(direction*diff,delta); 
    object.filters.alpha.opacity+=direction*delta; 
    if (object.filters.alpha.opacity != destOp){ 
        nereidFadeObjects[object.sourceIndex]=object; 
        nereidFadeTimers[object.sourceIndex]=setTimeout("nereidFade(nereidFadeObjects["+object.sourceIndex+"],"+destOp+","+rate+","+delta+")",rate); 
    } 
} 
</script> 
</head> 
<body onload="new Accordian('accordian',4,'header_highlight');"> 
<div id="wrap"> 
  <div id="apDiv2"> 
    <div style="text-align: left;"><img src="img/logotransparent.png" alt="" width="48" height="31" />    </div> 
  </div> 
  <div id="top">  
    <h2><a href="http://www.minizise.nl"><img src="img/header_.png" alt="" width="205" height="142" border="0" /></a></h2> 
    <div id="menu"> 
      <ul> 
        <li><a href="home.html">Home</a></li> 
        <li><a href="gallery.html">Gallery</a></li> 
        <li><a href="portfolio.html">Portfolio</a></li> 
      <li><a href="links.html">Links</a></li> 
      <li><a href="img/contact.png" class="lightwindow" title="" >Contact</a></li>      </ul> 
    </div> 
  </div> 
  <div id="content"> 
    <div id="left"> 
<h1 align="left"><img src="images/portfoliotag.png" alt="" width="200" height="75" /></h1> 
  <div id="accordian" > 
    <div class="accordion_headings header_highlight style3" id="test-header" >Minimal</div> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    <div id="test-content"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      <div class="accordion_child"> 
        <div align="justify"><span class="style3"><span class="style4"><a href="flash/diversed2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center" ><img src="images/lp_16.png" align="middle" /><strong> Diversed</strong></a> produced by <em><strong>Minizise</strong></em><br /> 
            </span></span> 
          <div align="justify"> 
              <div align="justify" class="style4"><a href="flash/dopefunk2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Dope Funk </strong></a>produced by <em><strong>Minizise</strong></em></div> 
              <div align="justify" class="style4"><a href="flash/milistic2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Milistic</strong></a> produced by <em><strong>Minizise</strong></em></div> 
              <div align="justify" class="style4"><a href="flash/miniziseminimal2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Minimize Minimal </strong></a>produced by <em><strong>Minizise</strong></em><br /> 
                <br /> 
                <br /> 
              </div> 
              <div align="justify"><strong><br /> 
              </strong></div> 
            </div> 
        </div> 
      </div> 
    </div> 
    <!--End of each accordion item--> 
    <!--Start of each accordion item--> 
    <div class="accordion_headings style3" id="test1-header" >Breakbeat</div> 
    <span class="style3"> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    </span> 
    <div class="style3" id="test1-content"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      <div class="accordion_child"> 
        <div align="justify"> <span class="style4"><a href="flash/darkavenue2.swf?scale=noscale" title="" class="lightwindow page-options" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Dark</strong> <strong>Avenue</strong></a> produced by <em><strong>Phonic</strong></em><br /> 
            </span> 
          <div align="justify"><span class="style2"><a href="flash/cronox2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="left"><img src="images/lp_16.png" align="middle" /><strong> Cronox</strong></a></span> <span class="style5">produced by <em><strong>Phonic</strong></em></span><br /> 
            <br /> 
          </div> 
        </div> 
      </div> 
    </div> 
    <span class="style3"> 
    <!--End of each accordion item--> 
    <!--Start of each accordion item--> 
    </span> 
    <div class="accordion_headings style3" id="test2-header" >Lounge</div> 
    <span class="style3"> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    </span> 
    <div class="style3" id="test2-content"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      <div class="accordion_child"> 
        <div align="justify"><span class="style4"><a href="flash/faith2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Faith</strong></a> produced by <em><strong>Minizise</strong></em><br /> 
            </span> 
          <div align="justify"> 
              <div align="justify"><span class="style4"><a href="flash/subrange2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> SubRange</strong></a> produced by <em><strong>Minizise</strong></em></span></div> 
            </div> 
        </div> 
      </div> 
    </div> 
    <span class="style3"> 
    <!--End of each accordion item--> 
    <!--Start of each accordion item--> 
    </span> 
    <div class="accordion_headings style3" id="test3-header" >Drum 'n Bass</div> 
    <span class="style3"> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    </span> 
    <div class="style3" id="test3-content"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      <div class="accordion_child"> 
        <div align="justify"><span class="style4"><a href="flash/fingertipz2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> FingerTipZ</strong></a> produced by <em><strong>Phonic</strong></em><br /> 
            </span> 
          <div align="justify"> 
              <div align="justify" class="style4"><a href="flash/forcesofnature2.swf?scale=noscale" title="" class="lightwindow page-options" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Forces</strong> <strong>of</strong> <strong>Nature</strong></a> produced by <em><strong>Phonic</strong></em></div> 
              <div align="justify" class="style4"><a href="flash/quicksilver2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Quicksilver</strong></a> produced by <em><strong>Phonic</strong></em><em><strong> | Bigeye</strong></em></div> 
              <div align="justify" class="style4"><a href="flash/newera2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> New Era</strong></a> produced by <em><strong>Phonic</strong></em></div> 
              <div align="justify"><span class="style4"><a href="flash/silverdices2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Silver Dices</strong></a> produced by <em><strong>Phonic</strong></em></span><strong><br /> 
              </strong></div> 
            </div> 
        </div> 
      </div> 
    </div> 
    <span class="style3"> 
    <!--End of each accordion item--> 

    <!--Start of each accordion item--> 
    </span> 
    <div class="accordion_headings style3" id="test5-header" >Hip Hop</div> 
    <span class="style3"> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    </span> 
    <div id="test5-content"> 
      <span class="style3"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      </span> 
      <div class="accordion_child"> 
        <div align="justify" class="style4"><a href="flash/wereldinmijnzak2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Wereld In Mijn Zak</strong></a> produced by <em><strong>Phonic</strong></em><em><strong> Bigeye </strong></em> Vocals by <em><strong>FirstClass</strong></em> Recorded at <strong><em>Astley Studio's</em></strong></div> 
      </div> 
    </div> 
    <span class="style3"> 
      <!--End of each accordion item--> 

      <!--Start of each accordion item--> 
    </span> 
      <div class="accordion_headings style3" id="test6-header" >New</div> 
      <span class="style3"> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    </span> 
    <div id="test6-content"> 
      <span class="style3"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      </span> 
      <div class="accordion_child"><em><strong>COMING SOON...</strong></em></div> 
    </div> 
    <p> 
      <!--End of each accordion item--> 

    </span>      </p> 
     </div> 
  </div> 
     <p align="right"> 
      <!-- Start of StatCounter Code --> 
      <script type="text/javascript"> 
var sc_project=2940428;  
var sc_invisible=1;  
var sc_partition=30;  
var sc_security="6ebacb5b";  
  </script> 
      <script type="text/javascript" src="http://www.statcounter.com/counter/counter_xhtml.js"></script> 
    </p> 
     <div id="right"> 
       <p align="right"><img src="img/untitled.gif" alt="" width="300" height="115" /><br /> 
       </p> 
       <div align="right"> 
         <p align="right"></p> 
         <th scope="col"><p id="player2"><img src="images/featuredtag.png" alt="" width="73" height="34" /> </p> 
             <div align="right"> 
               <p align="right"> 
                 <script type="text/javascript"> 
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8','name','MiniZise MP3 Player','width','270','height','140','id','MiniZise MP3 Player','pluginspage','http://www.macromedia.com/go/getflashplayer','wmode','transparent','bgcolor','#000000','src','mediaplayer','flashvars','file=playlist_minizise.xml&width=270&height=140&displaywidth=280&displayheight=0&overstretch=true&wmode=transparent&showicons=false&backcolor=0xffffff&frontcolor=0x666666&lightcolor=0xCCCCCC','movie','mediaplayer','quality','high','allowfullscreen','false','swliveconnect','true','allowscriptaccess','sameDomain' ); //end AC code 
       </script> 
               </p> 
             </div></th> 
       </div> 
       <span class="style7"></span><br /> 
       </th> 
       <td rowspan="2"></td> 
     </div> 
     <noscript> 
    <div class="statcounter"> 
      <div align="right"><a class="statcounter" href="http://www.statcounter.com/"><img class="statcounter" src="http://c31.statcounter.com/2940428/0/6ebacb5b/0/" alt="counter stats" /></a></div> 
    </div> 
    </noscript> 
    <!-- End of StatCounter Code --> 
    <p></p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <div align="center"> 
      <p> 
        <?php  
///////////////// eerst contact maken met de database //////////////////////  
<?php 
///////////////// eerst contact maken met de database //////////////////////
 $db = "mijn_database";
$dbuser = "user";
$dbpass = "pass";
$dbhost = "localhost";
$dbh=mysql_connect("$dbhost","$dbuser","$dbpass");
mysql_select_db( "$db" ) or trigger_error( mysql_error() );
//////////////// contact gemaakt met de database /////////////////
$page=$_SERVER['PHP_SELF'];
$article=$_GET['article'];
if($_GET['soort']=='reply'){
//////////////// een pagina voor het maken van de comments ////////////
$reply=$_GET['reply'];
	$article_id=$_GET['article_id'];

		echo "<center><h3>Comment</h3>";
	
		echo "<table width=85% border=0><form method='POST' action='$page?article_id=$article_id&soort=post'>";
		
		echo "<input type='hidden' name='article_id' value='$article_id'>";		
			echo "<tr align='center'><td>Post<td><TEXTAREA name='post_text' cols='60' rows='6'></TEXTAREA>";
		echo "<tr align='center'><td><td><input type='submit' name='post' value='Post'><input type='hidden' name='post' value='post'></form>";
		echo "</table>";
//////////////// einde pagina voor het maken van de comments ////////////	
}else{
//////////////// een pagina voor het laten zien van de comments ////////////

//////////////// eerst een klein stukje voor het posten /////////////

if($_GET['soort']='post' and $_POST['post']='post' and $_POST['post_text']!=''){
	
	$article_id=$_POST['article_id'];
	$post_text=$_POST['post_text'];
	$time=time();
$Query_post_in_forum="INSERT INTO `comments` (`ID`, `article_id`, `poster`, `post`, `time`) VALUES ('','$article_id','".$_SESSION['user_id']."', '$post_text', '$time')";
	$res_post_in_forum=mysql_query($Query_post_in_forum);
$fout=mysql_errno($dbh);
    if ($fout != 0) {
    $fout=mysql_error($dbh);
    echo "<font color=\#FF0000\"><center>An error occured. This is the error message:$fout. Error code: 1 <br> Sorry for the inconvenience.<br><br>The taridge admin team.</center></font>";
    mysql_close($dbh);
    echo "</body></html>";
    exit;
}
}
////////////// einde posten, nu de pagina /////////////
$article_id=$_GET['article_id'];
$query_select_post="SELECT * FROM `comments` where `article_id`='$article_id'";
$res_select_post=mysql_query($query_select_post);
$fout=mysql_errno($dbh);
    if ($fout != 0) {
    $fout=mysql_error($dbh);
    echo "<font color=\#FF0000\"><center>An error occured. This is the error message:$fout. <br> Sorry for the inconvenience.<br><br>The taridge admin team.</center></font>";
    mysql_close($dbh);
    echo "</body></html>";
    exit;
}

$aantal_posts_made=mysql_num_rows($res_select_post);
//$aantal_posts_made=3;
if($aantal_posts_made!=0){
	echo "<table>";
for($tellingnummer_post=0;$tellingnummer_post<$aantal_posts_made;$tellingnummer_post++){
$row_select_posts=mysql_fetch_assoc($res_select_post);

$poster=$row_select_posts['poster'];
if($poster==''){
	$poster='Anonymous';
}
$post=$row_select_posts['post'];

	echo "<tr align='center'><td width=22% style='border: 1px solid #C0C0C0;'>Poster: $poster<td style='border: 1px solid #C0C0C0;'>$post";	
}
echo "</table>";

}else{
echo "No post found.";	
}

}
echo "<center><h3>Comment</h3>";
	
		echo "<table width=85% border=0><form method='POST' action='$page?article_id=$article_id&soort=post'>";
		
		echo "<input type='hidden' name='article_id' value='$article_id'>";		
			echo "<tr align='center'><td>Post<td><TEXTAREA name='post_text' cols='60' rows='6'></TEXTAREA>";
		echo "<tr align='center'><td><td><input type='submit' name='post' value='Post'><input type='hidden' name='post' value='post'></form>";
		echo "</table>";
////////////////// einde van pagina voor het laten zien van de comments /////////// 
 ?>    
      <p>&nbsp;  </p> 
    </div> 
    <p>&nbsp;</p> 
    <p align="center" class="style9">&nbsp;</p> 
    <p align="center" class="style9"><span class="stijl3 style9 stijl8">Copyright 2007 Minizise | Design by </span><span class="stijl3 style12 stijl8 style4"><a href="mailto:omardezine@gmail.com"><strong>oMaR</strong></a></span><span class="stijl3 style12 stijl8 style13 style9"> | </span><span class="stijl3 stijl3 stijl8 style13 style9">Phonic AKA Minizise productions</span></p> 
  </div> 
</div> 
<div id="comments"> 
<span class="style9"><br /> 
  </span> 
<div class="style9" id="clear"></div> 
<div id="apDiv"><a href="#"><img src="images/top.png" alt="" width="37" height="54" border="0" class="box" style="filter:alpha(opacity=50)" onmouseover="nereidFade(this,100,30,5)" onmouseout="nereidFade(this,10,50,5)"/></a><br /> 
  </div> 
<div align="right"></div> 
</body> 
</html>
 
Ik denk dat je onderhand wel gek van me word nu, maar ik krijg nog steeds de output niet te zien van de comment die ik heb ingevoerd? Ik weet echt niet wat ik nu verkeerd doe
 
sorry, mij fout :eek:

hier is de goede (als het goed is) gehele code:

PHP:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> 

<head> 
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 
    <meta name="Minizise" content="All about music producer Phonic AKA Minizise" /> 
    <meta name="Minizise" content="phonic,minizise,drumm n bass,minimal" /> 
    <meta name="Minizise" content="music, producer, minimal, house, drum 'n bass, lounge" /> 
     
    <title>MiniZise.NL | Portfolio Comments_test</title> 

<!-- CSS scripts --> 

    <link rel="shortcut icon"                                 href="favicon.ico" />        
    <link rel="stylesheet"         type="text/css"             href="css/style.css"         media="screen" /> 
       
<!-- Smooth scripts --> 
    <script type="text/javascript" src="Scripts/js/smooth.pack.js"></script>         
<!-- Accordian scripts -->  
    <link rel="stylesheet"         type="text/css"            href="css/accordeon.css"         media="screen" />    
    <script type="text/javascript" src="Scripts/js/accordian.pack.js"></script> 
<!-- Lightbox scripts --> 
    <link rel="stylesheet"         type="text/css"             href="css/lightbox.css"        media="screen" />  
    <script type="text/javascript" src="Scripts/js/prototype.js"></script> 
    <script type="text/javascript" src="Scripts/js/scriptaculous.js?load=effects"></script> 
    <script type="text/javascript" src="Scripts/js/lightbox.js"></script> 
    <script type="text/javascript" src="Scripts/js/scriptaculous.js"></script> 
<!-- Lightwindow scripts --> 
    <link rel="stylesheet"         type="text/css"     href="css/lightwindow.css" />  
    <script type="text/javascript" src="Scripts/javascript/prototype.js"></script> 
    <script type="text/javascript" src="Scripts/javascript/effects.js"></script> 
    <script type="text/javascript" src="Scripts/javascript/lightwindow.js"></script> 
    <script type="text/javascript" src="Scripts/javascript/scriptaculous.js?load=effects"></script> 
<!-- Main scripts --> 
    <script type="text/javascript" src="Scripts/rel.js"></script> 
    <script type="text/javascript" src="Scripts/AC_ActiveX.js"></script> 
    <script type="text/javascript" src="Scripts/AC_RunActiveContent.js"></script> 
    <script type="text/javascript" src="Scripts/swfobject.js"></script> 
     
         
    <style type="text/css"> 
.stijl3 {color: #CCCCCC} 
.stijl4 { 
    color: #FFFFFF; 
    font-style: italic; 
} 
body,td,th { 
    font-size: 9px; 
    color: #666666; 
} 
a:visited { 
    color: #93B300; 
} 
a:hover { 
    color: #93B300; 
} 
a:active { 
    color: #93B300; 
} 
body { 
    background-color: #FFFFFF; 
    background-image: url(images/headerstripe_loop.jpg); 
} 
.stijl7 {color: #FFFFFF} 
.stijl8 {font-size: 9px} 
.stijl9 {font-style: italic} 
.stijl10 { 
    color: #000000; 
    font-style: italic; 
} 
.style2 { 
    color: #93B300; 
    font-family: Verdana, Arial, Helvetica, sans-serif; 
} 
#apDiv2 { 
    position:absolute; 
    width:154px; 
    height:32px; 
    z-index:1; 
    left: 1px; 
    top: 95px; 
} 
#apDiv1 { 
    position:absolute; 
    width:84px; 
    height:93px; 
    z-index:2; 
    left: 1px; 
    top: 1606px; 
} 
.style3 {font-family: "Lithos Pro Regular"} 
.style4 {font-family: Verdana, Arial, Helvetica, sans-serif} 
.style5 {color: #333333; font-family: Verdana, Arial, Helvetica, sans-serif; } 

#apDiv3 { 
    position:absolute; 
    width:29px; 
    height:57px; 
    z-index:2; 
    right: 20px; 
    top: 1511px; 
} 
.style7 {color: #ECE9D8} 
#apDiv { 
    position:absolute; 
    width:29px; 
    height:57px; 
    z-index:2; 
    right: 9px; 
    top: 1239px; 
} 
.style9 {color: #666666} 
--> 
    </style> 

<script> 
nereidFadeObjects = new Object(); 
nereidFadeTimers = new Object(); 
function nereidFade(object, destOp, rate, delta){ 
if (!document.all) 
return 
    if (object != "[object]"){   
        setTimeout("nereidFade("+object+","+destOp+","+rate+","+delta+")",0); 
        return;    }         
    clearTimeout(nereidFadeTimers[object.sourceIndex]); 
        diff = destOp-object.filters.alpha.opacity; 
    direction = 1;    if (object.filters.alpha.opacity > destOp){ 
        direction = -1;    } 
    delta=Math.min(direction*diff,delta); 
    object.filters.alpha.opacity+=direction*delta; 
    if (object.filters.alpha.opacity != destOp){ 
        nereidFadeObjects[object.sourceIndex]=object; 
        nereidFadeTimers[object.sourceIndex]=setTimeout("nereidFade(nereidFadeObjects["+object.sourceIndex+"],"+destOp+","+rate+","+delta+")",rate); 
    } 
} 
</script> 
</head> 
<body onload="new Accordian('accordian',4,'header_highlight');"> 
<div id="wrap"> 
  <div id="apDiv2"> 
    <div style="text-align: left;"><img src="img/logotransparent.png" alt="" width="48" height="31" />    </div> 
  </div> 
  <div id="top">  
    <h2><a href="http://www.minizise.nl"><img src="img/header_.png" alt="" width="205" height="142" border="0" /></a></h2> 
    <div id="menu"> 
      <ul> 
        <li><a href="home.html">Home</a></li> 
        <li><a href="gallery.html">Gallery</a></li> 
        <li><a href="portfolio.html">Portfolio</a></li> 
      <li><a href="links.html">Links</a></li> 
      <li><a href="img/contact.png" class="lightwindow" title="" >Contact</a></li>      </ul> 
    </div> 
  </div> 
  <div id="content"> 
    <div id="left"> 
<h1 align="left"><img src="images/portfoliotag.png" alt="" width="200" height="75" /></h1> 
  <div id="accordian" > 
    <div class="accordion_headings header_highlight style3" id="test-header" >Minimal</div> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    <div id="test-content"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      <div class="accordion_child"> 
        <div align="justify"><span class="style3"><span class="style4"><a href="flash/diversed2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center" ><img src="images/lp_16.png" align="middle" /><strong> Diversed</strong></a> produced by <em><strong>Minizise</strong></em><br /> 
            </span></span> 
          <div align="justify"> 
              <div align="justify" class="style4"><a href="flash/dopefunk2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Dope Funk </strong></a>produced by <em><strong>Minizise</strong></em></div> 
              <div align="justify" class="style4"><a href="flash/milistic2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Milistic</strong></a> produced by <em><strong>Minizise</strong></em></div> 
              <div align="justify" class="style4"><a href="flash/miniziseminimal2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Minimize Minimal </strong></a>produced by <em><strong>Minizise</strong></em><br /> 
                <br /> 
                <br /> 
              </div> 
              <div align="justify"><strong><br /> 
              </strong></div> 
            </div> 
        </div> 
      </div> 
    </div> 
    <!--End of each accordion item--> 
    <!--Start of each accordion item--> 
    <div class="accordion_headings style3" id="test1-header" >Breakbeat</div> 
    <span class="style3"> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    </span> 
    <div class="style3" id="test1-content"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      <div class="accordion_child"> 
        <div align="justify"> <span class="style4"><a href="flash/darkavenue2.swf?scale=noscale" title="" class="lightwindow page-options" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Dark</strong> <strong>Avenue</strong></a> produced by <em><strong>Phonic</strong></em><br /> 
            </span> 
          <div align="justify"><span class="style2"><a href="flash/cronox2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="left"><img src="images/lp_16.png" align="middle" /><strong> Cronox</strong></a></span> <span class="style5">produced by <em><strong>Phonic</strong></em></span><br /> 
            <br /> 
          </div> 
        </div> 
      </div> 
    </div> 
    <span class="style3"> 
    <!--End of each accordion item--> 
    <!--Start of each accordion item--> 
    </span> 
    <div class="accordion_headings style3" id="test2-header" >Lounge</div> 
    <span class="style3"> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    </span> 
    <div class="style3" id="test2-content"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      <div class="accordion_child"> 
        <div align="justify"><span class="style4"><a href="flash/faith2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Faith</strong></a> produced by <em><strong>Minizise</strong></em><br /> 
            </span> 
          <div align="justify"> 
              <div align="justify"><span class="style4"><a href="flash/subrange2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> SubRange</strong></a> produced by <em><strong>Minizise</strong></em></span></div> 
            </div> 
        </div> 
      </div> 
    </div> 
    <span class="style3"> 
    <!--End of each accordion item--> 
    <!--Start of each accordion item--> 
    </span> 
    <div class="accordion_headings style3" id="test3-header" >Drum 'n Bass</div> 
    <span class="style3"> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    </span> 
    <div class="style3" id="test3-content"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      <div class="accordion_child"> 
        <div align="justify"><span class="style4"><a href="flash/fingertipz2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> FingerTipZ</strong></a> produced by <em><strong>Phonic</strong></em><br /> 
            </span> 
          <div align="justify"> 
              <div align="justify" class="style4"><a href="flash/forcesofnature2.swf?scale=noscale" title="" class="lightwindow page-options" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Forces</strong> <strong>of</strong> <strong>Nature</strong></a> produced by <em><strong>Phonic</strong></em></div> 
              <div align="justify" class="style4"><a href="flash/quicksilver2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Quicksilver</strong></a> produced by <em><strong>Phonic</strong></em><em><strong> | Bigeye</strong></em></div> 
              <div align="justify" class="style4"><a href="flash/newera2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> New Era</strong></a> produced by <em><strong>Phonic</strong></em></div> 
              <div align="justify"><span class="style4"><a href="flash/silverdices2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Silver Dices</strong></a> produced by <em><strong>Phonic</strong></em></span><strong><br /> 
              </strong></div> 
            </div> 
        </div> 
      </div> 
    </div> 
    <span class="style3"> 
    <!--End of each accordion item--> 

    <!--Start of each accordion item--> 
    </span> 
    <div class="accordion_headings style3" id="test5-header" >Hip Hop</div> 
    <span class="style3"> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    </span> 
    <div id="test5-content"> 
      <span class="style3"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      </span> 
      <div class="accordion_child"> 
        <div align="justify" class="style4"><a href="flash/wereldinmijnzak2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Wereld In Mijn Zak</strong></a> produced by <em><strong>Phonic</strong></em><em><strong> Bigeye </strong></em> Vocals by <em><strong>FirstClass</strong></em> Recorded at <strong><em>Astley Studio's</em></strong></div> 
      </div> 
    </div> 
    <span class="style3"> 
      <!--End of each accordion item--> 

      <!--Start of each accordion item--> 
    </span> 
      <div class="accordion_headings style3" id="test6-header" >New</div> 
      <span class="style3"> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    </span> 
    <div id="test6-content"> 
      <span class="style3"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      </span> 
      <div class="accordion_child"><em><strong>COMING SOON...</strong></em></div> 
    </div> 
    <p> 
      <!--End of each accordion item--> 

    </span>      </p> 
     </div> 
  </div> 
     <p align="right"> 
      <!-- Start of StatCounter Code --> 
      <script type="text/javascript"> 
var sc_project=2940428;  
var sc_invisible=1;  
var sc_partition=30;  
var sc_security="6ebacb5b";  
  </script> 
      <script type="text/javascript" src="http://www.statcounter.com/counter/counter_xhtml.js"></script> 
    </p> 
     <div id="right"> 
       <p align="right"><img src="img/untitled.gif" alt="" width="300" height="115" /><br /> 
       </p> 
       <div align="right"> 
         <p align="right"></p> 
         <th scope="col"><p id="player2"><img src="images/featuredtag.png" alt="" width="73" height="34" /> </p> 
             <div align="right"> 
               <p align="right"> 
                 <script type="text/javascript"> 
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8','name','MiniZise MP3 Player','width','270','height','140','id','MiniZise MP3 Player','pluginspage','http://www.macromedia.com/go/getflashplayer','wmode','transparent','bgcolor','#000000','src','mediaplayer','flashvars','file=playlist_minizise.xml&width=270&height=140&displaywidth=280&displayheight=0&overstretch=true&wmode=transparent&showicons=false&backcolor=0xffffff&frontcolor=0x666666&lightcolor=0xCCCCCC','movie','mediaplayer','quality','high','allowfullscreen','false','swliveconnect','true','allowscriptaccess','sameDomain' ); //end AC code 
       </script> 
               </p> 
             </div></th> 
       </div> 
       <span class="style7"></span><br /> 
       </th> 
       <td rowspan="2"></td> 
     </div> 
     <noscript> 
    <div class="statcounter"> 
      <div align="right"><a class="statcounter" href="http://www.statcounter.com/"><img class="statcounter" src="http://c31.statcounter.com/2940428/0/6ebacb5b/0/" alt="counter stats" /></a></div> 
    </div> 
    </noscript> 
    <!-- End of StatCounter Code --> 
    <p></p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <div align="center"> 
      <p> 
        <?php  
///////////////// eerst contact maken met de database //////////////////////  
 $db = "mijn_database";
$dbuser = "user";
$dbpass = "pass";
$dbhost = "localhost"; 

$dbh=mysql_connect("$dbhost","$dbuser","$dbpass"); 
mysql_select_db( "$db" ) or trigger_error( mysql_error() ); 
//////////////// contact gemaakt met de database ///////////////// 
$page=$_SERVER['PHP_SELF']; 
$article=$_GET['article']; 
if($_GET['soort']=='reply'){ 
//////////////// een pagina voor het maken van de comments //////////// 
$reply=$_GET['reply']; 
    $article_id=$_GET['article_id']; 

        echo "<center><h3>Comment</h3>"; 
     
        echo "<table width=85% border=0><form method='POST' action='$page?article_id=$article_id&soort=post'>"; 
         
        echo "<input type='hidden' name='article_id' value='$article_id'>";         
            echo "<tr align='center'><td>Post<td><TEXTAREA name='post_text' cols='60' rows='6'></TEXTAREA>"; 
        echo "<tr align='center'><td><td><input type='submit' name='post' value='Post'><input type='hidden' name='post' value='post'></form>"; 
        echo "</table>"; 
//////////////// einde pagina voor het maken van de comments ////////////     
}else{ 
//////////////// een pagina voor het laten zien van de comments //////////// 

//////////////// eerst een klein stukje voor het posten ///////////// 

if($_GET['soort']='post' and $_POST['post']='post' and $_POST['post_text']!=''){ 
     
    $article_id=$_POST['article_id']; 
    $post_text=$_POST['post_text']; 
    $time=time(); 
$Query_post_in_forum="INSERT INTO `comments` (`ID`, `article_id`, `poster`, `post`, `time`) VALUES ('','$article_id','".$_SESSION['user_id']."', '$post_text', '$time')"; 
    $res_post_in_forum=mysql_query($Query_post_in_forum); 
$fout=mysql_errno($dbh); 
    if ($fout != 0) { 
    $fout=mysql_error($dbh); 
    echo "<font color=\#FF0000\"><center>An error occured. This is the error message:$fout. Error code: 1 <br> Sorry for the inconvenience.<br><br>The taridge admin team.</center></font>"; 
    mysql_close($dbh); 
    echo "</body></html>"; 
    exit; 
} 
} 
////////////// einde posten, nu de pagina ///////////// 
$article_id=$_GET['article_id']; 
$query_select_post="SELECT * FROM `comments` where `article_id`='$article_id'"; 
$res_select_post=mysql_query($query_select_post); 
$fout=mysql_errno($dbh); 
    if ($fout != 0) { 
    $fout=mysql_error($dbh); 
    echo "<font color=\#FF0000\"><center>An error occured. This is the error message:$fout. <br> Sorry for the inconvenience.<br><br>The taridge admin team.</center></font>"; 
    mysql_close($dbh); 
    echo "</body></html>"; 
    exit; 
} 

$aantal_posts_made=mysql_num_rows($res_select_post); 
//$aantal_posts_made=3; 
if($aantal_posts_made!=0){ 
    echo "<table>"; 
for($tellingnummer_post=0;$tellingnummer_post<$aantal_posts_made;$tellingnummer_post++){ 
$row_select_posts=mysql_fetch_assoc($res_select_post); 

$poster=$row_select_posts['poster']; 
if($poster==''){ 
    $poster='Anonymous'; 
} 
$post=$row_select_posts['post']; 

    echo "<tr align='center'><td width=22% style='border: 1px solid #C0C0C0;'>Poster: $poster<td style='border: 1px solid #C0C0C0;'>$post";     
} 
echo "</table>"; 

}else{ 
echo "No post found.";     
} 

} 
echo "<center><h3>Comment</h3>"; 
     
        echo "<table width=85% border=0><form method='POST' action='$page?article_id=$article_id&soort=post'>"; 
         
        echo "<input type='hidden' name='article_id' value='$article_id'>";         
            echo "<tr align='center'><td>Post<td><TEXTAREA name='post_text' cols='60' rows='6'></TEXTAREA>"; 
        echo "<tr align='center'><td><td><input type='submit' name='post' value='Post'><input type='hidden' name='post' value='post'></form>"; 
        echo "</table>"; 
////////////////// einde van pagina voor het laten zien van de comments /////////// 
?> 


      <p>&nbsp;  </p> 
    </div> 
    <p>&nbsp;</p> 
    <p align="center" class="style9">&nbsp;</p> 
    <p align="center" class="style9"><span class="stijl3 style9 stijl8">Copyright 2007 Minizise | Design by </span><span class="stijl3 style12 stijl8 style4"><a href="mailto:omardezine@gmail.com"><strong>oMaR</strong></a></span><span class="stijl3 style12 stijl8 style13 style9"> | </span><span class="stijl3 stijl3 stijl8 style13 style9">Phonic AKA Minizise productions</span></p> 
  </div> 
</div> 
<div id="comments"> 
<span class="style9"><br /> 
  </span> 
<div class="style9" id="clear"></div> 
<div id="apDiv"><a href="#"><img src="images/top.png" alt="" width="37" height="54" border="0" class="box" style="filter:alpha(opacity=50)" onmouseover="nereidFade(this,100,30,5)" onmouseout="nereidFade(this,10,50,5)"/></a><br /> 
  </div> 
<div align="right"></div> 
</body> 
</html>
 
Laatst bewerkt:
hier is de code met de nieuwe functie's:

PHP:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> 

<head> 
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 
    <meta name="Minizise" content="All about music producer Phonic AKA Minizise" /> 
    <meta name="Minizise" content="phonic,minizise,drumm n bass,minimal" /> 
    <meta name="Minizise" content="music, producer, minimal, house, drum 'n bass, lounge" /> 
     
    <title>MiniZise.NL | Portfolio Comments_test</title> 

<!-- CSS scripts --> 

    <link rel="shortcut icon"                                 href="favicon.ico" />        
    <link rel="stylesheet"         type="text/css"             href="css/style.css"         media="screen" /> 
       
<!-- Smooth scripts --> 
    <script type="text/javascript" src="Scripts/js/smooth.pack.js"></script>         
<!-- Accordian scripts -->  
    <link rel="stylesheet"         type="text/css"            href="css/accordeon.css"         media="screen" />    
    <script type="text/javascript" src="Scripts/js/accordian.pack.js"></script> 
<!-- Lightbox scripts --> 
    <link rel="stylesheet"         type="text/css"             href="css/lightbox.css"        media="screen" />  
    <script type="text/javascript" src="Scripts/js/prototype.js"></script> 
    <script type="text/javascript" src="Scripts/js/scriptaculous.js?load=effects"></script> 
    <script type="text/javascript" src="Scripts/js/lightbox.js"></script> 
    <script type="text/javascript" src="Scripts/js/scriptaculous.js"></script> 
<!-- Lightwindow scripts --> 
    <link rel="stylesheet"         type="text/css"     href="css/lightwindow.css" />  
    <script type="text/javascript" src="Scripts/javascript/prototype.js"></script> 
    <script type="text/javascript" src="Scripts/javascript/effects.js"></script> 
    <script type="text/javascript" src="Scripts/javascript/lightwindow.js"></script> 
    <script type="text/javascript" src="Scripts/javascript/scriptaculous.js?load=effects"></script> 
<!-- Main scripts --> 
    <script type="text/javascript" src="Scripts/rel.js"></script> 
    <script type="text/javascript" src="Scripts/AC_ActiveX.js"></script> 
    <script type="text/javascript" src="Scripts/AC_RunActiveContent.js"></script> 
    <script type="text/javascript" src="Scripts/swfobject.js"></script> 
     
         
    <style type="text/css"> 
.stijl3 {color: #CCCCCC} 
.stijl4 { 
    color: #FFFFFF; 
    font-style: italic; 
} 
body,td,th { 
    font-size: 9px; 
    color: #666666; 
} 
a:visited { 
    color: #93B300; 
} 
a:hover { 
    color: #93B300; 
} 
a:active { 
    color: #93B300; 
} 
body { 
    background-color: #FFFFFF; 
    background-image: url(images/headerstripe_loop.jpg); 
} 
.stijl7 {color: #FFFFFF} 
.stijl8 {font-size: 9px} 
.stijl9 {font-style: italic} 
.stijl10 { 
    color: #000000; 
    font-style: italic; 
} 
.style2 { 
    color: #93B300; 
    font-family: Verdana, Arial, Helvetica, sans-serif; 
} 
#apDiv2 { 
    position:absolute; 
    width:154px; 
    height:32px; 
    z-index:1; 
    left: 1px; 
    top: 95px; 
} 
#apDiv1 { 
    position:absolute; 
    width:84px; 
    height:93px; 
    z-index:2; 
    left: 1px; 
    top: 1606px; 
} 
.style3 {font-family: "Lithos Pro Regular"} 
.style4 {font-family: Verdana, Arial, Helvetica, sans-serif} 
.style5 {color: #333333; font-family: Verdana, Arial, Helvetica, sans-serif; } 

#apDiv3 { 
    position:absolute; 
    width:29px; 
    height:57px; 
    z-index:2; 
    right: 20px; 
    top: 1511px; 
} 
.style7 {color: #ECE9D8} 
#apDiv { 
    position:absolute; 
    width:29px; 
    height:57px; 
    z-index:2; 
    right: 9px; 
    top: 1239px; 
} 
.style9 {color: #666666} 
--> 
    </style> 

<script> 
nereidFadeObjects = new Object(); 
nereidFadeTimers = new Object(); 
function nereidFade(object, destOp, rate, delta){ 
if (!document.all) 
return 
    if (object != "[object]"){   
        setTimeout("nereidFade("+object+","+destOp+","+rate+","+delta+")",0); 
        return;    }         
    clearTimeout(nereidFadeTimers[object.sourceIndex]); 
        diff = destOp-object.filters.alpha.opacity; 
    direction = 1;    if (object.filters.alpha.opacity > destOp){ 
        direction = -1;    } 
    delta=Math.min(direction*diff,delta); 
    object.filters.alpha.opacity+=direction*delta; 
    if (object.filters.alpha.opacity != destOp){ 
        nereidFadeObjects[object.sourceIndex]=object; 
        nereidFadeTimers[object.sourceIndex]=setTimeout("nereidFade(nereidFadeObjects["+object.sourceIndex+"],"+destOp+","+rate+","+delta+")",rate); 
    } 
} 
</script> 
</head> 
<body onload="new Accordian('accordian',4,'header_highlight');"> 
<div id="wrap"> 
  <div id="apDiv2"> 
    <div style="text-align: left;"><img src="img/logotransparent.png" alt="" width="48" height="31" />    </div> 
  </div> 
  <div id="top">  
    <h2><a href="http://www.minizise.nl"><img src="img/header_.png" alt="" width="205" height="142" border="0" /></a></h2> 
    <div id="menu"> 
      <ul> 
        <li><a href="home.html">Home</a></li> 
        <li><a href="gallery.html">Gallery</a></li> 
        <li><a href="portfolio.html">Portfolio</a></li> 
      <li><a href="links.html">Links</a></li> 
      <li><a href="img/contact.png" class="lightwindow" title="" >Contact</a></li>      </ul> 
    </div> 
  </div> 
  <div id="content"> 
    <div id="left"> 
<h1 align="left"><img src="images/portfoliotag.png" alt="" width="200" height="75" /></h1> 
  <div id="accordian" > 
    <div class="accordion_headings header_highlight style3" id="test-header" >Minimal</div> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    <div id="test-content"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      <div class="accordion_child"> 
        <div align="justify"><span class="style3"><span class="style4"><a href="flash/diversed2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center" ><img src="images/lp_16.png" align="middle" /><strong> Diversed</strong></a> produced by <em><strong>Minizise</strong></em><br /> 
            </span></span> 
          <div align="justify"> 
              <div align="justify" class="style4"><a href="flash/dopefunk2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Dope Funk </strong></a>produced by <em><strong>Minizise</strong></em></div> 
              <div align="justify" class="style4"><a href="flash/milistic2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Milistic</strong></a> produced by <em><strong>Minizise</strong></em></div> 
              <div align="justify" class="style4"><a href="flash/miniziseminimal2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Minimize Minimal </strong></a>produced by <em><strong>Minizise</strong></em><br /> 
                <br /> 
                <br /> 
              </div> 
              <div align="justify"><strong><br /> 
              </strong></div> 
            </div> 
        </div> 
      </div> 
    </div> 
    <!--End of each accordion item--> 
    <!--Start of each accordion item--> 
    <div class="accordion_headings style3" id="test1-header" >Breakbeat</div> 
    <span class="style3"> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    </span> 
    <div class="style3" id="test1-content"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      <div class="accordion_child"> 
        <div align="justify"> <span class="style4"><a href="flash/darkavenue2.swf?scale=noscale" title="" class="lightwindow page-options" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Dark</strong> <strong>Avenue</strong></a> produced by <em><strong>Phonic</strong></em><br /> 
            </span> 
          <div align="justify"><span class="style2"><a href="flash/cronox2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="left"><img src="images/lp_16.png" align="middle" /><strong> Cronox</strong></a></span> <span class="style5">produced by <em><strong>Phonic</strong></em></span><br /> 
            <br /> 
          </div> 
        </div> 
      </div> 
    </div> 
    <span class="style3"> 
    <!--End of each accordion item--> 
    <!--Start of each accordion item--> 
    </span> 
    <div class="accordion_headings style3" id="test2-header" >Lounge</div> 
    <span class="style3"> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    </span> 
    <div class="style3" id="test2-content"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      <div class="accordion_child"> 
        <div align="justify"><span class="style4"><a href="flash/faith2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Faith</strong></a> produced by <em><strong>Minizise</strong></em><br /> 
            </span> 
          <div align="justify"> 
              <div align="justify"><span class="style4"><a href="flash/subrange2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> SubRange</strong></a> produced by <em><strong>Minizise</strong></em></span></div> 
            </div> 
        </div> 
      </div> 
    </div> 
    <span class="style3"> 
    <!--End of each accordion item--> 
    <!--Start of each accordion item--> 
    </span> 
    <div class="accordion_headings style3" id="test3-header" >Drum 'n Bass</div> 
    <span class="style3"> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    </span> 
    <div class="style3" id="test3-content"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      <div class="accordion_child"> 
        <div align="justify"><span class="style4"><a href="flash/fingertipz2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> FingerTipZ</strong></a> produced by <em><strong>Phonic</strong></em><br /> 
            </span> 
          <div align="justify"> 
              <div align="justify" class="style4"><a href="flash/forcesofnature2.swf?scale=noscale" title="" class="lightwindow page-options" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Forces</strong> <strong>of</strong> <strong>Nature</strong></a> produced by <em><strong>Phonic</strong></em></div> 
              <div align="justify" class="style4"><a href="flash/quicksilver2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Quicksilver</strong></a> produced by <em><strong>Phonic</strong></em><em><strong> | Bigeye</strong></em></div> 
              <div align="justify" class="style4"><a href="flash/newera2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> New Era</strong></a> produced by <em><strong>Phonic</strong></em></div> 
              <div align="justify"><span class="style4"><a href="flash/silverdices2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Silver Dices</strong></a> produced by <em><strong>Phonic</strong></em></span><strong><br /> 
              </strong></div> 
            </div> 
        </div> 
      </div> 
    </div> 
    <span class="style3"> 
    <!--End of each accordion item--> 

    <!--Start of each accordion item--> 
    </span> 
    <div class="accordion_headings style3" id="test5-header" >Hip Hop</div> 
    <span class="style3"> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    </span> 
    <div id="test5-content"> 
      <span class="style3"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      </span> 
      <div class="accordion_child"> 
        <div align="justify" class="style4"><a href="flash/wereldinmijnzak2.swf?scale=noscale" title="" class="page-options lightwindow" params="lightwindow_width=494,lightwindow_height=94" align="center"><img src="images/lp_16.png" align="middle" /><strong> Wereld In Mijn Zak</strong></a> produced by <em><strong>Phonic</strong></em><em><strong> Bigeye </strong></em> Vocals by <em><strong>FirstClass</strong></em> Recorded at <strong><em>Astley Studio's</em></strong></div> 
      </div> 
    </div> 
    <span class="style3"> 
      <!--End of each accordion item--> 

      <!--Start of each accordion item--> 
    </span> 
      <div class="accordion_headings style3" id="test6-header" >New</div> 
      <span class="style3"> 
    <!--Heading of the accordion ( clicked to show n hide ) --> 
    <!--Prefix of heading (the DIV above this) and content (the DIV below this) to be same... eg. foo-header & foo-content--> 
    </span> 
    <div id="test6-content"> 
      <span class="style3"> 
      <!--DIV which show/hide on click of header--> 
      <!--This DIV is for inline styling like padding...--> 
      </span> 
      <div class="accordion_child"><em><strong>COMING SOON...</strong></em></div> 
    </div> 
    <p> 
      <!--End of each accordion item--> 

    </span>      </p> 
     </div> 
  </div> 
     <p align="right"> 
      <!-- Start of StatCounter Code --> 
      <script type="text/javascript"> 
var sc_project=2940428;  
var sc_invisible=1;  
var sc_partition=30;  
var sc_security="6ebacb5b";  
  </script> 
      <script type="text/javascript" src="http://www.statcounter.com/counter/counter_xhtml.js"></script> 
    </p> 
     <div id="right"> 
       <p align="right"><img src="img/untitled.gif" alt="" width="300" height="115" /><br /> 
       </p> 
       <div align="right"> 
         <p align="right"></p> 
         <th scope="col"><p id="player2"><img src="images/featuredtag.png" alt="" width="73" height="34" /> </p> 
             <div align="right"> 
               <p align="right"> 
                 <script type="text/javascript"> 
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8','name','MiniZise MP3 Player','width','270','height','140','id','MiniZise MP3 Player','pluginspage','http://www.macromedia.com/go/getflashplayer','wmode','transparent','bgcolor','#000000','src','mediaplayer','flashvars','file=playlist_minizise.xml&width=270&height=140&displaywidth=280&displayheight=0&overstretch=true&wmode=transparent&showicons=false&backcolor=0xffffff&frontcolor=0x666666&lightcolor=0xCCCCCC','movie','mediaplayer','quality','high','allowfullscreen','false','swliveconnect','true','allowscriptaccess','sameDomain' ); //end AC code 
       </script> 
               </p> 
             </div></th> 
       </div> 
       <span class="style7"></span><br /> 
       </th> 
       <td rowspan="2"></td> 
     </div> 
     <noscript> 
    <div class="statcounter"> 
      <div align="right"><a class="statcounter" href="http://www.statcounter.com/"><img class="statcounter" src="http://c31.statcounter.com/2940428/0/6ebacb5b/0/" alt="counter stats" /></a></div> 
    </div> 
    </noscript> 
    <!-- End of StatCounter Code --> 
    <p></p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <p>&nbsp;</p> 
    <div align="center"> 
      <p> 
        <?php  
///////////////// eerst contact maken met de database //////////////////////  
 $db = "mijn_database";
$dbuser = "user";
$dbpass = "pass";
$dbhost = "localhost"; 

$dbh=mysql_connect("$dbhost","$dbuser","$dbpass"); 
mysql_select_db( "$db" ) or trigger_error( mysql_error() ); 
//////////////// contact gemaakt met de database ///////////////// 
$page=$_SERVER['PHP_SELF']; 
$article=$_GET['article']; 
if($_GET['soort']=='reply'){ 
//////////////// een pagina voor het maken van de comments //////////// 
$reply=$_GET['reply']; 
    $article_id=$_GET['article_id']; 

        echo "<center><h3>Comment</h3>"; 
     
        echo "<table width=85% border=0><form method='POST' action='$page?article_id=$article_id&soort=post'>"; 
         
        echo "<input type='hidden' name='article_id' value='$article_id'>";         
            echo "<tr align='center'><td>Post<td><TEXTAREA name='post_text' cols='60' rows='6'></TEXTAREA>"; 
        echo "<tr align='center'><td><td><input type='submit' name='post' value='Post'><input type='hidden' name='post' value='post'></form>"; 
        echo "</table>"; 
//////////////// einde pagina voor het maken van de comments ////////////     
}else{ 
//////////////// een pagina voor het laten zien van de comments //////////// 

//////////////// eerst een klein stukje voor het posten ///////////// 

if($_GET['soort']='post' and $_POST['post']='post' and $_POST['post_text']!=''){ 
     
    $article_id=$_POST['article_id'];
    $poster=$_POST['poster']; 
    $post_text=nl2br($_POST['post_text']); 
    $time=time(); 
$Query_post_in_forum="INSERT INTO `comments` (`ID`, `article_id`, `poster`, `post`, `time`) VALUES ('','$article_id','$poster', '$post_text', '$time')"; 
    $res_post_in_forum=mysql_query($Query_post_in_forum); 
$fout=mysql_errno($dbh); 
    if ($fout != 0) { 
    $fout=mysql_error($dbh); 
    echo "<font color=\#FF0000\"><center>An error occured. This is the error message:$fout. Error code: 1 <br> Sorry for the inconvenience.<br><br>The taridge admin team.</center></font>"; 
    mysql_close($dbh); 
    echo "</body></html>"; 
    exit; 
} 
} 
////////////// einde posten, nu de pagina ///////////// 
$article_id=$_GET['article_id']; 
$query_select_post="SELECT * FROM `comments` where `article_id`='$article_id'"; 
$res_select_post=mysql_query($query_select_post); 
$fout=mysql_errno($dbh); 
    if ($fout != 0) { 
    $fout=mysql_error($dbh); 
    echo "<font color=\#FF0000\"><center>An error occured. This is the error message:$fout. <br> Sorry for the inconvenience.<br><br>The taridge admin team.</center></font>"; 
    mysql_close($dbh); 
    echo "</body></html>"; 
    exit; 
} 

$aantal_posts_made=mysql_num_rows($res_select_post); 
//$aantal_posts_made=3; 
if($aantal_posts_made!=0){ 
    echo "<table>"; 
for($tellingnummer_post=0;$tellingnummer_post<$aantal_posts_made;$tellingnummer_post++){ 
$row_select_posts=mysql_fetch_assoc($res_select_post); 

$poster=$row_select_posts['poster']; 
if($poster==''){ 
    $poster='Anonymous'; 
} 
$post=$row_select_posts['post']; 
$post_time=$row_select_posts['time'];
$post_time_format=date("m-j-Y, g:i a", $post_time);
    echo "<tr align='center'><td width=22% style='border: 1px solid #C0C0C0;'>Poster: $poster<br>$post_time_format<td style='border: 1px solid #C0C0C0;'>$post";     
} 
echo "</table>"; 

}else{ 
echo "No post found.";     
} 

} 
echo "<center><h3>Comment</h3>"; 
     
        echo "<table width=85% border=0><form method='POST' action='$page?article_id=$article_id&soort=post'>"; 
         
        echo "<input type='hidden' name='article_id' value='$article_id'>";
        echo "<tr align='center'><td>Name<td><input type='text' name='poster' maxlength='100'>";
            echo "<tr align='center'><td>Post<td><TEXTAREA name='post_text' cols='60' rows='6'></TEXTAREA>"; 
        echo "<tr align='center'><td><td><input type='submit' name='post' value='Post'><input type='hidden' name='post' value='post'></form>"; 
        echo "</table>"; 
////////////////// einde van pagina voor het laten zien van de comments /////////// 
?> 
     
      <p>&nbsp;  </p> 
    </div> 
    <p>&nbsp;</p> 
    <p align="center" class="style9">&nbsp;</p> 
    <p align="center" class="style9"><span class="stijl3 style9 stijl8">Copyright 2007 Minizise | Design by </span><span class="stijl3 style12 stijl8 style4"><a href="mailto:omardezine@gmail.com"><strong>oMaR</strong></a></span><span class="stijl3 style12 stijl8 style13 style9"> | </span><span class="stijl3 stijl3 stijl8 style13 style9">Phonic AKA Minizise productions</span></p> 
  </div> 
</div> 
<div id="comments"> 
<span class="style9"><br /> 
  </span> 
<div class="style9" id="clear"></div> 
<div id="apDiv"><a href="#"><img src="images/top.png" alt="" width="37" height="54" border="0" class="box" style="filter:alpha(opacity=50)" onmouseover="nereidFade(this,100,30,5)" onmouseout="nereidFade(this,10,50,5)"/></a><br /> 
  </div> 
<div align="right"></div> 
</body> 
</html>
 
Hey Haroim

Nogmaals bedankt voor je hulp ik waardeer t zeer van je dat je me geholpen hebt.

wat had je hierin veranderd?
PHP:
CREATE TABLE `comments` ( 
  `ID` tinyint(100) NOT NULL auto_increment, 
  `article_id` tinyint(100) NOT NULL, 
  `poster` varchar(100) NOT NULL, 
  `post` text NOT NULL, 
  `time` varchar(40) NOT NULL, 
  PRIMARY KEY  (`ID`) 
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
niets, ik had het alleen handmatig opnieuw ingevoerd. Ik zou voor de zekerheid wel een backup van die invoering maken. Weet je hoe dat moet?

Ik vermoed trouwens dat de fout te maken had met de verschillende mysql versie's.

dit zou altijd moeten werken:
PHP:
CREATE TABLE `comments` (  
  `ID` tinyint(100) NOT NULL auto_increment,  
  `article_id` tinyint(100) NOT NULL,  
  `poster` varchar(100) NOT NULL,  
  `post` text NOT NULL,  
  `time` varchar(40) NOT NULL,  
  PRIMARY KEY  (`ID`)  
) ENGINE=InnoDB
 
mooie site trouwens (had ik nog niet gezegd :p). een klein foutje: je intro wijst naar home.html in plaats van home.php

heb je de site helemaal zelf gemaakt?
 
thanks! Ja zelf gemaakt. Ik moet nog ff een nieuw intro'tje maken, goed gezien ;)
 
ik zie een paar lightwindows (lightbox). Dat is eigenlijk nog wel iets waar ik wat meer over wil weten. Ik weet dat er wel wat standaart lightwindows op het internet te verkrijgen zijn, maar als ik er een wil wil ik deze zelf helemaal kunnen aanpassen. Heb jij die zelf aangepast en zo ja, heeft dat veel tijd gekost en was het voor jouw lastig?
 
ik was hem al tegen gekomen, maar toch nog bedankt.

succes verder met je site :thumb:
 
Toch nog een vraagje :eek: Hoe kan ik de comments aflopend ipv oplopend zetten?
 
voeg achter de query ORDER BY ID DESC

(of het was ORDER BY ID ACS, ik haal die twee altijd door elkaar :p)
 
AAARGH! error in query - error in query - error in query - error in query - error in query -!!!
 
Error
SQL query:

CREATE TABLE `comments` (

`ID` tinyint( 100 ) NOT NULL AUTO_INCREMENT ORDER BY ID DESC ,
`article_id` tinyint( 100 ) NOT NULL ,
`poster` varchar( 100 ) NOT NULL ,
`post` text NOT NULL ,
`time` varchar( 40 ) NOT NULL ,
PRIMARY KEY ( `ID` )
) ENGINE = InnoDB
MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY ID DESC,
`article_id` tinyint(100) NOT NULL,
`poster` varch' at line 2
 
ehmm.... ik was misschien niet helemaal duidelijk..

ik bedoelde het volgende:

PHP:
$query_select_post="SELECT * FROM `comments` where `article_id`='$article_id' ORDER BY `ID` DECS;"
 
Woohoo! had je me weer ff laten zweten, thanks nu laat ik je echt met rust :D
 
Status
Niet open voor verdere reacties.
Terug
Bovenaan Onderaan