SELECT multiples

[Neuron_376]

Algo mas eficiente es con JOIN, utiliza esto:

SELECT c.id AS `data`, u.username AS `label`, c.comment, c.date, c.active
FROM `comments` AS `c`
JOIN `phpbb_users` AS `u` on c.id_author LIKE u.user_id
WHERE c.id_new LIKE '1'
ORDER BY c.id

Si esto te funciona, sera mucho mas eficiente, los select multiples son muy ineficientes.