[StreetGT]

Quote:

Originally Posted by zPain There's no need for 2 queries. You can write a JOIN statemente based on the user id. PHP Code: SELECT     tickets.*,     spieler.name AS username FROM     tickets INNER JOIN     spieler ON spieler.id = tickets.userid WHERE     tickets.status=0

Thats it! Anyway if you want to check about JOIN query's take a look!
http://dev.mysql.com/doc/refman/5.7/en/join.html