PHP - Delete Comment In Comment Box

I have a comment form that I have created. It gets the id from the database and prints out the data that goes with that id, but what it also does is prints out the information into the form. I want a blank form so that the user can add a comment to the record.

Any ideas?

This the code for the form:
Code: [Select]
<form method="post" action="pv.php?id=<?php echo $row['ID']?>&action=<?php echo $form_action ?>">
<fieldset>
    <legend></legend>
    <p>
        <label for="cname">Date Of Birth</label>  *
        <input id="cname" name="dateofbirth" class="required date"  value="<?php echo $row['Date_Of_Birth']?>" />  (eg 1978.11.11)
    </p>
    <p>
        <label for="cgender">Gender</label>   *
        <input type="radio" name="gender" value="Male" <?php if($row['Gender']=='male'){echo 'checked';}?>/> Male <input type="radio" name="gender" value="Female" <?php if($row['Gender']=='female'){echo 'checked';}?>/> Female </td>
    </p>
    <p>
        <label for="curl">Title</label>   *
        <select name="title"   id="title"  class="required">
            <option value="">Please Select</option>
            <option value="Mr" <?php if($row['Title']=='Mr'){echo 'selected';}?>>Mr</option>
            <option value="Ms" <?php if($row['Title']=='Ms'){echo 'selected';}?>>Ms</option>
            <option value="Mrs" <?php if($row['Title']=='Mrs'){echo 'selected';}?>>Mrs</option>
            <option value="Miss" <?php if($row['Title']=='Miss'){echo 'selected';}?>>Miss</option>
            <option value="Other" <?php if($row['Title']=='Other'){echo 'selected';}?>>Other</option>
            </select>
    </p>
    <p>
        <label for="ccomment">First Name</label>     *
        <input type="text" name="firstname" value="<?php echo $row['First_Name']?>" maxlength="50" />
    </p>


    <p>
    <label for="cemail">Last Name</label> *
        <input id="cemail" type="text" name="lastname" value="<?php echo $row['Last_Name']?>" maxlength="75" />
   </p>
    <p>
        <label for="ccomment">Address 1</label>*
        <input type="text" name="address1" value="<?php echo $row['Address_Line_1']?>" maxlength="50" /> 
    </p>
    <p>
        <label for="ccomment">Address 2</label>
        <input type="text" name="address2" value="<?php echo $row['Address_Line_2']?>" maxlength="50" />
    </p>
    <p>
        <label for="ccomment">City</label>*
        <input type="text" name="city" value="<?php echo $row['City']?>"  maxlength="50" />
    </p>
    <p>
        <label for="ccomment">Postcode</label>*
        <input type="text" name="postcode" value="<?php echo $row['Postcode']?>" maxlength= "10" />  (eg LE5 5QE)
    </p>
    <p>
        <label for="ccomment">Contact No</label>*
        <input type="text" name="contactno" value="<?php echo $row['Contact_No']?>" maxlength= "12" />  (eg 077448825723)
    </p>
    <p>
        <label for="ccomment">Email</label>*
        <input type="text" name="email" value="<?php echo $row['Email']?>" maxlength= "40"/>  (eg info@example.com)
    </p>
    <p>
        <label for="ccomment">Comment</label>
        <textarea rows="10" cols="30" name="note"  maxlength= "500"><?php echo $row['Additional_Comment']?></textarea>
    </p>
    <p>
        <input class="submit" type="submit" value="Submit"/>
    </p>
    <p>
    <a href='pv.php'>Main Page</a>
   </p>

</fieldset>

This is the code for printing out the data on the page:

Code: [Select]
if($_GET['action']=='comment'){
    $form_action = 'comment_ok';
    $id=$_GET['id'];
    $result = mysql_query("SELECT * FROM project_data WHERE id='$id'");
    $row = mysql_fetch_array($result);

    echo'<b>';
      echo $row['Date_Of_Birth'];
      echo '&nbsp&nbsp';
      echo $row['Gender'];
      echo '&nbsp&nbsp';
      echo $row['Title'];
      echo '&nbsp&nbsp';
      echo $row['First_Name'];
      echo '&nbsp&nbsp';
      echo $row['Last_Name'];
      echo '&nbsp&nbsp';
      echo $row['Address_Line_1'];
      echo '&nbsp&nbsp';
      echo $row['Address_Line_2'];
      echo '&nbsp&nbsp';
      echo $row['City'];
      echo '&nbsp&nbsp';
      echo $row['Postcode'];
      echo '&nbsp&nbsp';
      echo $row['Contact_No'];
      echo '&nbsp&nbsp';
      echo $row['Email'];
      echo '&nbsp&nbsp';
      echo $row['Additional_Comment'];
      echo '</b>';



 }



and a snippet of the code I am using to send the id to the form:

Code: [Select]
echo "<td><a href='pv.php?action=edit&id=" . $row['ID']."'>Edit</a>&nbsp&nbsp<a href='pv.php?action=delete_ok&id=" . $row['ID']."'>Delete</a>&nbsp&nbsp<a href='pv.php?action=comment&id=" . $row['ID']."'>Comment</a></td>";
      echo "</tr>";

I've got a comment box that connects to a MySQL database. I've got this error message here when I use the PHP include function to call on this script on my main page http://www.inkzoid.com/index.php ...

<?php

// calling session_start() the function which starts our authentication session
session_start();

// connecting to mysql server
$l = mysql_connect  ( "999.999.999.999" , "inkzoid" , "999) or die("Error connecting:<BR><BR>".mysql_error());
mysql_select_db( "inkzoid" ) or die("Error getting db:<BR><BR>".mysql_error());

// defining getShouts() which is our function that gets all of our shouts
function getShouts()
{

   echo '<div align="center">
      <table width="150" border="0" cellspacing="0" cellpadding="0">
        <tr>
         <td>
   ';   
   
   $query = mysql_query("SELECT * FROM shouts ORDER BY id DESC LIMIT 10") or die(mysql_error());
   while ($row = mysql_fetch_array($query) )
   {
      
      $name = stripslashes($row['Name']);
      $contact = stripslashes($row['Contact']);
      $shout = stripslashes($row['Shout']);
      
      if(empty($contact))
      {
      
         echo '<p><span class="author">'.$name.'</span> - <span class="shout">'.$shout.'</span></p>';
         
      } else {
      
         echo '<p><span class="author"><a href="'.$contact.'" target="_blank">'.$name.'</a></span> - <span class="shout">'.$shout.'</span></p>';

      } // if empty contact
            
   } // while row mysqlfetcharray query
   
   echo '<br><br>';
   
   echo '
         </td>
        </tr>
        <tr>
         <td height="10">&nbsp;</td>
         <form name="shout" method="post" action="shout.php">
           <div align="center">
            <input name="name" type="text" id="name" value="Name" size="25" maxlength="10"><br>
            <input name="contact" type="text" id="contact" value="http://" size="25"><br>
            <input name="message" type="text" id="message" value="Message" size="25"><br>
            <input name="shout" type="submit" id="shout" value="Shout!">
           </div>
         </form>
         </td>
        </tr>
        </table>
        </div>
      ';   

} // function getshouts


// our processing if control statement
if ( isset ( $_POST['shout'] ) )
{
   
   $name = addslashes($_POST['name']);
   $contact = addslashes($_POST['contact']);
   $message =  $_POST['message'];
   
   if ( ( isset($name) ) && ( isset($message) ) )
   {
      
      // getting smilie list
      $smilies = mysql_query("SELECT * FROM smilies") or die(mysql_error());
      while($get = mysql_fetch_array ($smilies))
      {
         
         $alt = $get['Alt'];
         $smilie = $get['URL'];
         
         $message = str_replace( $get['Symbol'] , '<img src="smilies/'.$smilie.'" border="0" width="15" height="15" alt="'.$alt.'">' , $message);
         $themessage = addslashes($message);
         
         // replacing all smilies
               
      }
   
      mysql_query("INSERT INTO shouts (Name, Contact, Shout) VALUES ( '$name' , '$contact' , '$message' )") or die(mysql_error());
      $_SESSION['has_posted'] = 'yes';
      header("Location: shout.php");
      
      // if required fields aren't empty, process into database
      
   } else {
   
      echo '<script>alert("Some fields were not filled out!");</script>';
      header("Location: shout.php");
      
      // if required fields were left empty, show an error dialog
      
   }

}/* else {

   echo '<script>alert("Please follow the form to this page.");</script>';
   header("Location: shout.php");
   
   // if they weren't even referred from the form, show error dialog and redirect

} // if isset post shout

/* STARTING THE MAIN SCRIPT NOW */

// starting the table

//displaying the shouts
getShouts();


mysql_close($l);


?>

I was told that I should put ob_start(); at the top of my page and ob_end_clear(); at the end of my page, but should that code go on the shout.php file or my index.php file (index.php is where I want my comment box to go)? I was using session_start(); but I got some error messsages about headers already being sent because I had originally used the php include function at the top of index.php to include shout.php. After reading up on it I found out that the error was caused by not having session_start(); being the first line of code. So my problem was that I wanted the comment box to be somewhere other than at the top of the page. Not sure how to move it.

Anyways I'm pretty confused right now and if someone could give me some advice it would be appreciated.

Good Afternoon everyone.

I am having some problems in getting a script I found on a forum to work, I have tried contacting the original author but with no joy.

Basically its a php/ajax comment system, however I am getting these errors

Code: [Select]
Notice: Undefined index: type in C:\wamp\www\buy2earn\viewm.php on line 93

Notice: Undefined index: type in C:\wamp\www\buy2earn\viewm.php on line 105
Here is the portion of code that I am working on, I don't understand what $_post['type'] is meant to come from? I guess its basically if the form has been submitted, but if I change the values tp 'submit' I still get the same result, just with the message submit is undefined instead!


<?php 
$date=date("Y-m-d"); 
$username = $_SESSION['username'];

if($_POST['type'] == "addcomment") {
    $username = mysql_real_escape_string($_POST['username']);
    $comment = mysql_real_escape_string($_POST['comment']);
    
    if($username == "" || $comment == "") { 
        die("<p><font color='red'>Error: Please include a message.</font></p>"); 
    }
    $q1 = mysql_query("INSERT INTO 'comments' ('c_id', 'm_id', 'username', 'date', 'comment')
VALUES ('', '$m_id', '$username', '$date', '$comment')")
 or die("<p>Mysql Error: <b>".mysql_error()."</b></p>");
 
    echo "<p><font color='green'>Comment added successfully.</font></p>";
} elseif($_POST['type'] == "getcomments") { 
    $q1 = mysql_query("SELECT * FROM 'comments'");
    $n1 = mysql_num_rows($q1);
    if($n1 == 0) { 
        die("<p><font color='red'>No comments were found.</font></p>");
    }
    echo "<table border=1>";
    echo "<tr><td><b>User</b></td><td><b>Comment</b></td></tr>";
    while($r1 = mysql_fetch_assoc($q1)) { 
        $a = $r1['username'];
        $m = $r1['comment'];
        echo "<tr><td>$a</td><td>$m</td></tr>";
    }
    echo "</table>";
} else {?>
    <div style="font-size: 18px;">
        <p>Current Comments: </p>
        <div id="comments"></div> 
        <hr />
        <p>Add a comment:</p>
        <form action="<?php $_SERVER['PHP_SELF'];?>" method="post">
            <p>Username: <input type="text" name="username" id="username" /></p>
            <p>Comment: <textarea name="message" cols="50" rows="10" id="message"></textarea></p>
            <p><input type="submit" name="submit" value="Add Comment" id="submit" /></p>
        </form>
        <div id="return"></div> 
    </div>
    

<?php } ?>
    

Many Thanks for any help

Hi, can anyone help show me or tell me where I can find out how I can create a comment box system that will get the members userid/username and post it with the comment when it has been submitted on the page. e.g the way youtube displays comments with the username and then the comment underneath.

thanks,

Hi,

I'm trying to improve my coding and would appreciate if someone could comment and alter my code.
I dont know what would work best, named placeholders or question mark placeholders. Place the variables in a array first and then do the binding.

Im looking also for solutions regarding record update using place holders.

Thanks

    $idnrr = 1;
    $users = DB::getInstance()->query("SELECT * FROM users WHERE id = :id1", array(':id1' => $idnrr));
    if ($users->count()) {
        foreach ($users->results() as $result) {
            echo $result->name . "<br />";
        }
    }

public function query($sql, $params) {
        $this->_error = false;
        if ($this->_query = $this->_pdo->prepare($sql)) {
            $x = 1;
           

            if ($this->_query->execute($params)) {
                $this->_results = $this->_query->fetchAll(PDO::FETCH_OBJ);
                $this->_count = $this->_query->rowCount();
            } else {
                $this->_error = true;
            }
        }

        return $this;
    }

Hi everyone,
I have a like button on repeating regions that is used for keeping a record of votes on comments.
People click it an it adds 1 to the votes column total.

It works just fine.

Problem is i only want to a allow a user one vote per comment only. can vote on other comments as well, but again, only one vote per day per comment.

i wouldn't know where to start.
Would i use a cookie or record an ip?

switch ($_REQUEST['action']) {
case 'likeit';

foreach($_REQUEST as $key=>$value){
$$key = $value;
}
$votes = $_GET['votes'];
$total = ($votes + 1);

$sql = mysql_query("UPDATE quotes SET votes = '$total' WHERE quoteid = '$quoteid'");

break;

}

I'm trying to get my head around oop and wondered if anyone would look at my comments so far .
I want to learn a bit about constructors next but thought I should make sure I understand the below code properly first.

Code: [Select]
<?php
class Dictionary {
//new class

public $translations = array();
    public $type =" ";
//new variables called 'PROPERTIES'

function summarize() { 
//function within a class is called a 'METHOD'
        $ret  = "Dictionary type: {$this->type}\n"; 
// {$this->type} means: use $type which is found within THIS class
        $ret .= "Terms: ".count( $this->translations )."\n";  
// {$this->type} means: count the length of the $translation array which is found within THIS class
        return $ret;
    }
}
?>

Code: [Select]
<?php
include('class_dictionary.php'); 
//include file that holds the class

$english = new Dictionary;   // creating new object using the class called Dictionary
$english->type = "EN";       // adding a value to the 'type' property located within the dictionary class
$english->translations['TREE'] = "branch";  //adding TREE key and value branch to the translations array
$english->translations['TREEtwo'] = "trunk"; //adding TREEtwo key and value trunk to the translations array

$french = new Dictionary;  //creating a new instance of the Dictionary object
$french->type = "FR";
$french->translations['TREE'] = "arbre";

print_r( $english ); 

echo "<br/>";
print $english->summarize();  //prints the summarize method
?>

i want that when someone post some comment on post that don't insert in table directly before inserting i can check and after approving then insert in table for which what i doo ?any IDea about this

Hi guys I'm trying to modify the following script so that only registered users can post comments.  Can you guys help please thanks?
<?php

require_once("admin_common.php");

session_start();

if(is_numeric($_REQUEST['id'])){
$imageid = $_REQUEST['id'];
}else{
header("Location: http://mysite.net/");
}

if($_POST['submit']){
if($_POST['username']==''){
$err = "You must log in.";
}elseif($_POST['thecomment']==''){
$err = "You have to enter a comment.";
}else{
$name = strip_tags($_POST['thename']);
$themessage = strip_tags($_POST['thecomment']);
$ezdb->get_results("INSERT INTO user_comments (id,date_added, posted_by, message, image_id) VALUE ('','".time()."','".$name."','".$themessage."','".$imageid."')");
$err = "Thank you for your comment.";
}
}

if($err){
$err = '<span style="color:#FF0000;">'.$err.'</span>';
}

/* Update table `iid_ip`.

Between the dashed lines is the create statement used to create the image view count (iid_ip) table.

----------------------------------------
delimiter $$

CREATE TABLE `iid_ip` (
  `iid` int(11) unsigned NOT NULL COMMENT 'Image id from where the count is the number of unique views.',
  `ip` varchar(15) NOT NULL COMMENT 'The ip of the visitor.',
  PRIMARY KEY (`iid`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Table for view count of image using unique ip''s.'$$
----------------------------------------

*/// Escape variables that are used in the query.
$_ip  = mysql_real_escape_string($_SERVER['REMOTE_ADDR']);
$_iid = mysql_real_escape_string($imageid);

// Count is 0 if ip has NOT seen the images, else count is 1
$_count = $ezdb->get_var("SELECT COUNT(*) FROM `iid_ip` WHERE `iid`='$_iid' AND `ip`='$_ip'");
if (!$_count) {
// Insert the unique combination of image id and visitor ip in `iid_ip`.
// Method doesn't exists! $ezdb->quick_insert('iid_ip', array('iid' => $_iid, 'ip' => $_ip));
$ezdb->get_results("INSERT INTO `iid_ip` (`iid`,`ip`) VALUES ('$_iid','$_ip')");
}
// Get count of image views.
$_views = $ezdb->get_var("SELECT COUNT(*) FROM `iid_ip` WHERE `iid`='$_iid'");
// And format, thousands seperator is a comma, no decimals.
$_views = number_format($_views, 0, '', ',');

/////////////////////////////

$page->addHTMLHead($scripthead);

$d[] = "<div id='imagedetails'>";

$imgs = $ezdb->get_results("Select * From image_map Where id='".$imageid."'");
$name = $ezdb->get_var("Select name From `".$imgs[0]->obj_type."s` WHERE id ='".$imgs[0]->obj_id."'");
if($imgs[0]->obj_type=='comment') $pg='comm';
if($imgs[0]->obj_type=='image') $pg='img';
$d[] = "<a href='imagepage.php?".$pg."=".$imgs[0]->obj_id."' style='text-decoration:none;'>&laquo;".ucfirst($imgs[0]->obj_type)."s - $name</a><br /><br />";
// DEFINE SIMPLE GRID
if ($imgs[0]->user_id != 0) { 
$theuser = $ezdb->get_var("SELECT username FROM users WHERE user_id='".$imgs[0]->user_id."'");
} else { 
$theuser = $imgs[0]->creator_name;
}
$d[]="<div style='float:left; width:450px; text-align:center;'>
<a href='contact.php'><img src='assets/images/leftAdjpg'></a>
            <br />
<div style='font-size:12px;  margin-top:30px; margin-left:5px;'>
".'Html Code: Use for websites, blogs, profiles and myspace.<br /><input name="textfield3" type="text" class="imagedetails_links" id="textfield3" onclick="this.select();this.focus()" value="&lt;a href=&quot;http://www.mysite.net/imagedetails.php?id='.$imageid.'&quot;&gt;&lt;img src=&quot;http://www.mysite.net/uploads/'.$imgs[0]->link.'&quot; border=&quot;0&quot; alt=&quot; &quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;a href=&quot;http://www.mysite.net&quot;&gt;&lt;/a&gt;" size="70" /> <br />


For posting in forums use this: <input name="textfield6" type="text" class="imagedetails_links" id="textfield6" onclick="this.select();this.focus()" value="[url=http://www.mysite.net][img]http://www.mysite.net/uploads/'.$imgs[0]->link.'[/img][/url]" size="70" /> <br />
</div>

<div style="float:left; width:450px; margin-left:34px; margin-top:5px;"><table width="100" border="0">
  <tr>
    <td class="widgets"><a href="http://twitter.com/share" class="twitter-share-button" data-count="vertical">Tweet</a><script type="text/javascript" src="http://platform.twitter.com/widgets.js"></script></td>
    <td class="widgets"><iframe src="http://www.facebook.com/plugins/like.php?href=http%3A%2F%2Fmysite.net%2F&amp;layout=box_count&amp;show_faces=false&amp;width=450&amp;action=like&amp;font=arial&amp;colorscheme=light&amp;height=65" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:450px; height:65px;" allowTransparency="true"></iframe></td>
  </tr>
</table></div>

';



if(ereg('.gif',$imgs[0]->link)){
$thelarge ="<img src='uploads/".$imgs[0]->link."' alt='".$imgs[0]->name."' style='border:0px solid #cccccc;' />";
}else{
$thelarge ="<img src='imageresize.php?imagepath=uploads/".$imgs[0]->link."&width=500&height=500' alt='".$imgs[0]->name."' style='border:0px solid #cccccc;' />";
}

$d[]="
</div>
<div style='float:left; margin-left:10px;'>
<p style='padding:0; margin:0; margin-right:20px; text-align:center; font-size:14px;'><a href='force.php?path=uploads/".$imgs[0]->link."'>Click to Download Image</a></p><br />
".$thelarge."

<div style='overflow:auto; clear:both'>
<div style='float:left; text-align: left;'>
Image: <span style='color:#FFFFFF;'>{$imgs[0]->name}</span><br />
<span style='color:#ffffff; font-size:13px;'>Posted on: ".date('m-d-Y',$imgs[0]->date_added)." by ".ucfirst($theuser)."</span>
</div>
<div style='float:right'>
<!-- Insert unique view count -->
<span style='color:#ffffff; font-size:13px;'>Views: $_views</span>
</div>
</div>
".'
</div>

<div style="clear:both;"></div>
<div style="margin:0 auto;"><br />'.$err.'
<form action="'.$_SERVER['PHP_SELF'].'" method="post" style="margin:0 auto; width:400px; color:#ffffff; font-size:11px; text-align:left;">
<div style="margin-bottom:5px;">Leave a comment:</div><input type="hidden" name="id" value="'.$imageid.'" />
Your name: <input type="text" name="thename" style="width:250px;" class="inputfields" value="'.$_SESSION['username'].'"/><br />
Your comment:<br /><textarea name="thecomment" style="width:400px; height:70px;" cols="50" rows="4" class="textareas" ></textarea><br />
<input type="submit" name="submit" value="Post Comment" style="float:right;"/>
</form>
</div>';

$getallcomments = $ezdb->get_results("SELECT * FROM user_comments WHERE image_id='".$imageid."' ORDER BY date_added DESC");
$uclist = '<div style="margin:0 auto; width:410px; padding:5px; border:0px solid #cccccc; margin-top:40px;">';
if(sizeof($getallcomments)>0){
foreach ($getallcomments as $ac){
$uclist .='<div style="border-bottom:2px solid #333333; width:400px; color:#ffffff; font-size:12px; margin:0 auto; text-align:left;"><br />Posted on:<span style="color:#000000;"> '.date('m-d-Y',$ac->date_added).' at '.date('H:i a',$ac->date_added).'.</span><br />Posted by:<span style="color:#000000;"> '.strip_tags($ac->posted_by).'</span><br /><span style="color:#ffffff;">'.strip_tags($ac->message).'</span></div>';
}
}else{
$uclist.='<div style="border-bottom:2px solid #ffffff; width:400px; color:#ffffff; font-size:12px; margin:0 auto; text-align:center;">Be the first to leave a comment!</div>';
}
$uclist.="</div><div style='clear:both;'></div><br /><br />";

$d[] = $uclist."</div>";

$page->add($d);
echo $page->render();

?>

Hi all i hope to find cure to my problems 
here is code of comment link
<a href='/blogs/?page=comment&id=".$row['id']."'>Comment</a> 
here is code of whole comment page http://paste.php.lv/4c30d2286cdd7334d856ce966abc618f?lang=php
And here is Pictures what's is going on on website....
Here is my main issue there are 3 comment's and they all well make such mess ....

and if there aren't any comment's have such issue ....

I would love to add a comment section to my music blogging site. Does anyone have some simple code that they would not mind sending me? or at least helping me with this situation?

Any one no a simple way to create a numbering system for a basic comment system.

Code: [Select]
<body>
   <?php
$commentsTable = "comments";
     $comments = "SELECT * FROM  $commentsTable";
$commentResults = mysql_query($comments);
$commentRows = mysql_fetch_array($commentResults);
?>
<div id="BodyWrapper">
    <?php while($commentRows = mysql_fetch_array($commentResults)){?>
    <div id="comments">
    <div id="CommentWrapper">
            <div id="comment">
                <div id="UserName"><? echo $commentRows['name'];?></div>
                <div id="UserComment"><? echo $commentRows['comment'];?></div>
                <div id="UserEmail"><? echo $commentRows['email'];?></div>
                <div id="PostDateTime"><? echo $commentRows['datatime'];?></div>
            </div>
        </div>
    </div>
<?php } mysql_close(); ?>
</div>

</body>
This is what i have, i want to create a limit of 5 comment but with nummber so you can view older posts.

Ok, so I want to make a comment spam filter for my site.  I know the basic logic, but have yet to figure out how to write the functions.  I have a database table called comments that has a column called "time", which contains a unix timestamp value of when it was posted.  Basically what I want to do is this:

When a user tries to post a comment, the script determines with a database query if they have posted a comment in the last 120 seconds.

So basically I have to find the current time, and the time it was 120 seconds before the current time.  Then I have to find any comments posted by the user that were made after the 120 second mark.

My database query should then look something like this, right?

Code: [Select]
$query = mysql_query("SELECT * FROM comments WHERE author = ".$_SESSION['id']." AND time > '".$120secondsago"'");

Please correct me if my logic is wrong, which it very well may be, but how would I find the unix timestamp code from 120 seconds before the current time?  Note that 120 seconds is just an example and also that I have not worked with dates in mysql very often.

$query = mysql_query("SELECT * FROM comments WHERE author = ".$_SESSION['id']." AND time

This is new. For some reason, the PHP errors are not counting my //commented lines.   Example:

<?php
//my comment
:
?>

Parse error: syntax error, unexpected ':' in D:\www\myscript.php on line 2   The error is on line 3. If I add more comments, the error is the same:

<?php
//my comment
//my comment
//my comment
//my comment
//my comment
:
?>

Parse error: syntax error, unexpected ':' in D:\www\myscript.php on line 2   Where is this setting? Thanks.

Hi guyz,

I am looking to create a dymanic comment box for my website where already logged in users can comment on webpages.

It is quite a challenge getting to dynamically display only the comments a particular user posted on a web page.

What I mean is I would like to be able to click on a page, see only the comments logged users posted on that page, and then post my own comment on that page. At the moment I created a comment box for my webpages but the issue is my posted comments on one particular page is displaying on all web pages with is comment system..This is the problem and it is very difficult to find helpful material hopefully you guyz can come to the rescue.

Please guys any help or suggestions are more than welcome.

Thanks

Kdiamonds