MahtabNihar
December 5, 2021, 7:41pm
#1
How Can I get names filtering by their winning point?
https://www.sqlshack.com/learn-mysql-sorting-and-filtering-data-in-a-table/
Hello friends i need a help in mysql syntax in rank functions .
[image]
This query i get the rank of all user in table
SELECT Name,
Score,
TimeLeft,
@curRank := @curRank + 1 AS rank
FROM Math_Contest_11122019, (SELECT @curRank := 0) r
ORDER BY Score DESC;
Now i want get a single user rank
SELECT MobileNo, Score, TimeLeft, FIND_IN_SET( Score, (
SELECT GROUP_CONCAT( Score
ORDER BY Score DESC, TimeLeft DESC )
FROM Math_Contest_111220119)
) AS rank
FROM Math_Contest_11122019
WHERE …
Hello friends,
I have published a basic tutorial on MySQLi and PHP in the App Inventor Community, I think it is better to put a link in this forum so as not to repeat the same thing.
The tutorial deals with 3 examples:
1.- MySQLi + PHP + GET
2.- MySQLi + PHP + POST
3.- MySQLi + PHP + Web page
In these examples I use the 000webhost server.
The forum link is:
I have also put it in Spanish:
App inventor. App inventor y MySQLi. PHP. GET. POST. Página web. Base de datos
[mysqlwebhost9]
[…
Use Select Query formula
Rogerio_Rios
December 5, 2021, 11:02pm
#3
Hi. This is a relational database subject that provides thousands of materials for study and research. Search for the “Select” SQL command. It’s just a few hours of research and understanding. After that, with your skill, you will be able to fetch the records you want from the database.
MahtabNihar
December 6, 2021, 12:57pm
#4
@Rogerio_Rios @Still-learning I am using Mysql extension by deephost. How can I do with it?
MahtabNihar:
deephost
Then you won’t get any answer i hope from our community.
dora_paz
December 6, 2021, 1:18pm
#8
Questions regarding DeepHost’s extensions aren’t allowed in the community. Contact the developer instead. Topic closed and unlisted
