Hi,

die Tabellennamen musst Du noch anpassen:

 
 
SELECT t1.id, t1.name, t1.subject, t2.user_name, UNIX_TIMESTAMP( TIME ) AS TIME
FROM forum_entries AS t1, forum_userdata AS t2
WHERE t1.user_id <> 0
AND t1.user_id = t2.user_id
OR t1.user_id = 0
ORDER BY t1.TIME DESC 
LIMIT 0 , 5
 
 

Jetzt steht der Name in name. Sollte dort nichts drin sein, steht er in user_name.

Micha