Help with mysql, not working...

[MDanz]

what i'm trying to do is every term that is searched is inserted into mysql, if the term is already there it adds 1 to the counter.  this code doesn't work, where did i go wrong?

counter is INT type...

<?php  
$search = $_GET['search'];

mysql_connect("localhost", "Master", "password");
mysql_select_db("db");

$bad2 = mysql_query("SELECT * FROM tags WHERE tagName='$search'");
$num_rows2 = mysql_num_rows($bad2) or die (mysql_error());

if($num_rows2==0){

$query10 = "INSERT INTO tags";
      $query10 .= "(`tagName`,`counter`) VALUES ('$search','1')";
  mysql_query($query10) or die (mysql_error());
}
elseif($num_rows2>0) {

$query11=  mysql_query("UPDATE tags SET counter=+1 WHERE tagName='$search' ") or die (mysql_error());

}

?>

[premiso]

$query11=  mysql_query("UPDATE tags SET counter=counter+1 WHERE tagName='$search' ") or die (mysql_error());

 

Give that a try.

[MDanz]

thx, that part now works but this part doesn't, i rephrased it but still not working.

 

if($num_rows2<1){

$query10 = mysql_query("INSERT INTO tags (`tagName`,`counter`) VALUES ('$search',1)") or die (mysql_error());
   
    
}

[fenway]

Define "not working".