hello there, hope someone can help me with this ...

PHP Code:

<?php
 $dbtable  = 'atx_tags';

 $db_conn  = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
 $db_found = mysql_select_db($dbname);

 if(isset($_POST['submit'])){
  $Tag       = $_POST['Tag'];
  $Date      = date('Y-m-d');

  $query = "INSERT INTO " . $dbtable . " (Tag,Date) VALUES ('$Tag','$Date')";
  mysql_query($query);

 }

?>

<form action="" method="post">
 <input name="Tag" class="input" type="text"><br>
 <input type="submit" name="submit" class="input2" value="Submit">
</form>

how i can make if Tag is already added on atx_tags to dont add again and to show echo error video already added ! ... hope someone can help me with this ...

Run a query to see if it exists in the table and if not display an error otherwise insert the video.

Also, you need to secure your inputs. You're inserting unvalidated data which is dangerous!

hello there, can you give me the full command for that becouse im kinda noob with this ... and about secure just me i have access to add the tags

With mysql, you can use the "ON DUPLICATE KEY" keyword:
http://dev.mysql.com/doc/refman/5.0/...duplicate.html

hello there, i try this command but still not working ... hope someone can tell me what is the problem ...

 if(isset($_POST['submit'])){
  $Tag       = $_POST['Tag'];
  $Date      = date('Y-m-d');
  $Color     = $color_tag;


  function tagExists($Tag)
  {
    $query = "SELECT TID FROM " . $dbtable . " WHERE Tag = " . $Tag . " LIMIT 1";
    mysql_query($query);
    return $tagExists;
  }
  
  if ($tagExists) {
   echo 'Tag Already Exist';
  } else {
   $query = "INSERT INTO " . $dbtable . " (Tag,Date,Color) VALUES ('$Tag','$Date','$Color')";
   mysql_query($query);
   echo 'Tag Added';
  }
 }

Given that "Tag" is your primary key, change the insert query to:

PHP Code:

$query = "INSERT INTO " . $dbtable . " (Tag,Date,Color) VALUES ('$Tag','$Date','$Color') ON DUPLICATE KEY UPDATE date=now(), Color=$color";