Posts by Vinicius Sousa • 31 points
3 posts
-
1
votes4
answers1444
viewsA: Excel transpose row to column and preserves columns and replicate them in row
I created the code below by the example you gave. Change the Worksheets(1) and Worksheets(2) according to the worksheet with the origin and the worksheet that will serve as the destination. Public…
-
1
votes5
answers325
viewsA: Php View Columns
I think it is more efficient and simple if executed by mysql $query = "SELECT id, A, B FROM table WHERE CHAR_LENGTH(B) >=8"; $recordset = mysqli_query($query, $link);…
-
1
votes1
answer235
viewsA: Grab the latest message from a conversation (GROUP BY)
I would make a inner join with a sub query: Select a.* From cp_mensagem a Join ( SELECT id_projeto, id_freelancer, max(cp_mensagem.dh_envio) as dh_envio FROM cp_mensagem WHERE id_pessoa = 6 AND…