I need to know how to do a comment script in php for that I can use on every video on my site but have the comments be per video using mysql. can someone help

If you mean so people can comment on your posted videos, I can. Now, if your videos are on a static page, like an HTML file, you'll have to create a new table for each video and (duh: convert it to a PHP file). Assuming you can create a table and connect to your db,... you do it something like this.

<form action="[php]<?php echo $_SERVER['PHP_SELF']; ?>[/php]" method="post">
<input type="text" name="name" />
<textarea cols="45" rows="5" name="comment"></textarea>
<input type="submit" name="subcom" value=" Submit Comment " />
</form>

PHP Code:

<?php
  if(isset($_POST['subcom'])){
    $sql = "INSERT INTO video1_comment (Name, Comment)
             VALUES('$_POST[name]','$_POST[comment]')";
    mysql_query($sql);
    $result = mysql_query("SELECT * FROM video1_comment");
    while($row=mysql_fetch_array($result))
    {
       echo "Name: &nbsp; " . $row['Name'];
       echo "Comment: &nbsp; " . $row['comment'];
    }
?>

I'm pretty sure that you know how to change this for your own needs.

I hope this is what your looking for.

If you have posted the videos with PHP and MySQL then I will give you the script for that.

Gah 'killdude69' got in there before me

It's true what he put, but don't put the '[php]' and '[\php]' parts.

On that bombshell I can also recommends a bit a AJAX, try something like:

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" target="funiframe">
<input type="text" name="name" />
<textarea cols="45" rows="5" name="comment"></textarea>
<input type="submit" name="subcom" value=" Submit Comment " />
<iframe name="funiframe" id="funiframe" src="" style="visibility: hidden;"></iframe>
</form>

Using the above code can mean the user never needs to leave the page

now if the videos were inserted into a database instead of embeded into a static page, it would be more like: (the id is in thre URL)

PHP Code:

<?php
  $id = $_GET['id'];
?>

<-- for goes here, it is on the same page as the processing script. -->
  <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
  <input type="text" name="name" />
  <input type="hidden" name="id" value="<?php echo $id; ?>" />
  <textarea name="comment" cols="45" rows="5"></textarea>
</form>

PHP Code:

<?php
  //id: not null, auto_increment, int(4)
  $sql = "INSERT INTO videos (Name, Comment, Id) WHERE id = $id
           VALUES('$_POST[name]','$_POST[comment]','$_POST[id]')";
  mysql_query($sql);
  $result=mysql_query("SELECT * FROM video WHERE id = $id");
  $row=mysql_fetch_array($video);
  //video display
?>
<table border="0">
 <tr>
  <td align="center"><?php echo $row['video_embed']; ?></td>
 </tr>
</table>
<br /><br />
<table border=0>
 <tr>
  <th>Name: </th>
  <th>Comment: </th>
 </tr>
<?php
  $result=mysql_query("SELECT * FROM video_comment WHERE id=$id");
  while($row=mysql_fetch_array($result)){
?>
 <tr>
  <td><?php echo $row['Name']; ?></td>
 </tr>
 <tr>
  <td align="center"><?php echo $row['Comment']; ?></td>
 </tr>
<?php } ?>
</table>

Hope this helped!