Posts by Guilherme Andre • 56 points
4 posts
-
1
votes4
answers131
viewsA: MAX with LIMIT does not give the correct result
It is that when you assign a MAX(age) column it will bring only the oldest age column in all search lines. Following the Maniero response line, you can select only one record of the older person…
-
0
votes2
answers388
viewsA: How do replace in all fields except one?
In this case use UPDATE instead of REPLACE UPDATE table SET camporecebido1 = 1, camporecebido2 = 1234, camporecebido3 = "texto", meucampo1 = 32 WHERE XXXX=YYY and UPDATE table SET camporecebido1 =…
-
1
votes1
answer734
viewsA: Edit data in modal filled with php database data
I noticed a syntax error in your code that may not allow you to find the correct id of what you want to edit: url: 'editafoto.php=id' + id, Where I should actually pass: url: 'editafoto.php?id=' +…
-
2
votes4
answers79
viewsA: Find names in 2 different tables
You can use "UNION" however, you would need to have the same column names to be included in both "SELECT", however, you can make a small "adjustment" allowing knowing the result if you are a user or…