Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

New answers tagged


Your second select query does what you want ... - deliver all imageupload entries - together with who took it and where / when - and who marked it favorite ... I suggest you put a proper alias for favorites.uid to make it more prominent http://sqlfiddle.com/#!9/b04a03/4 SELECT CASE WHEN favorites.uid=1 THEN 1 ELSE 0 END AS `my_favorite`,...

Top 50 recent answers are included