$query = 'soad'; $check = mysql_query("SELECT * FROM stats WHERE name='$query'"); if(mysql_num_rows($check) > 0){ $assoc = mysql_fetch_assoc($check); $update = mysql_query("UPDATE stats SET num='".$assoc['num']++."' WHERE id='".$assoc['id']."'"); }else{ $add = mysql_query("INSERT INTO stats VALUE(NULL,'".$query."','1')"); }