No consigo hacerlo funcionar bien.
Te dejo la estructura de las dos tablas.
TABLA COMMENTS
Código TXT:
Ver original+------------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| id_noticia | int(11) | NO | | NULL | |
| time | text | NO | | NULL | |
| nombre | text | NO | | NULL | |
| email | text | NO | | NULL | |
| show-email | int(2) | NO | | NULL | |
| status | int(2) | NO | | NULL | |
| comment | text | NO | | NULL | |
| ip | text | NO | | NULL | |
| fecha | text | NO | | NULL | |
| hora | text | NO | | NULL | |
| neg | int(11) | NO | | 0 | |
| pos | int(11) | NO | | 0 | |
+------------+---------+------+-----+---------+----------------+
TABLA RESPONSES
Código TXT:
Ver original+------------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| id_noticia | int(11) | NO | MUL | NULL | |
| id_comment | int(11) | NO | | NULL | |
| time | text | NO | | NULL | |
| nombre | text | NO | | NULL | |
| email | text | NO | | NULL | |
| status | int(2) | NO | | NULL | |
| response | text | NO | | NULL | |
| ip | text | NO | | NULL | |
| fecha | text | NO | | NULL | |
| hora | text | NO | | NULL | |
| pos | int(11) | NO | | 0 | |
| neg | int(11) | NO | | 0 | |
+------------+---------+------+-----+---------+----------------+