users
uid | name | lastname | profilepic
comments
sid | author | time | text
comments_likes
wid | wsid | wautors
SQL:
$whatsnew_sql = mysql_query("
SELECT comm.*, u.uid,`name`,`lastname`,`profilepic`, coommlk.*
FROM `comments` comm, `users` u, `comments_likes` commlk
WHERE comm.author = u.uid
ORDER BY `comm.sid` DESC LIMIT 12
");
Rezultātā vajadzētu izvadīt komentārus un ja tabulā `comments_likes` `wid` ir vienāds ar `comments` `sid` tad vajadzēja parādīties sirsniņai. Bet nez kkas tur nav kā vajag