Posts by Viernanryck • 26 points
3 posts
-
1
votes3
answers405
viewsA: Select only latest Mysql Chat messages
Got it! and I’m still sending the unread rsrsrsrsr thanks to all for the answers! SELECT * FROM( SELECT m.data, IF(m.dono=43, 0 ,(SELECT COUNT(*) FROM mensagens WHERE (dono=m.dono and dest=43 and…
-
0
votes1
answer505
viewsA: How do I query passed by get in id Pdo to code
I think that’s what you want: require 'conexao.php'; // Recebe o codigo do cliente do cliente via GET $codigo= (isset($_GET['codigo'])) ? $_GET['codigo'] : ''; //isset vai testar se existe "codigo"…
-
-1
votes3
answers405
viewsQ: Select only latest Mysql Chat messages
I’m creating a chat on an android app and I need to display this screen: My database looks like this: Table messages: I am making a this example query for the user who has id=43 SELECT m.dono,…