求教一个mysql_query函数的有关问题
求教一个mysql_query函数的问题
因为要做排行，所以用到
set @mycnt = 0;
select (@mycnt := @mycnt + 1) as rank,nick_name,total_scores,start_time,expire_time from of_user_exam left join of_user_basic on of_user_exam.user_id = of_user_basic.user_id order by -total_scores,expire_time;
这样两句话，但是两句话放到一个字符串里面用mysql_query执行不了，请问有没有别的方法可以得到结果？
------解决方案--------------------
mycnt的意义是什么，如果是1，2，3，4，5，6，7，8这样的序号，何必在sql语句中？
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Monotonic clock processing of time package
Aug 04, 2023 pm 05:45 PM
Today we are mainly going to take a look at the time application method of golang time package. The general rule between the two is that "wall time" is used to tell time, and "monotonic clock" is used to measure time; there are other clock processing methods.
How to solve the problem of docker mounting directory permissions
Feb 29, 2024 am 10:04 AM
In Docker, the permission problem of the mounting directory can usually be solved by the following method: adding permission-related options when using the -v parameter to specify the mounting directory. You can specify the permissions of the mounted directory by adding: ro or :rw after the mounted directory, indicating read-only and read-write permissions respectively. For example: dockerrun-v/host/path:/container/path:roimage_name Define the USER directive in the Dockerfile to specify the user running in the container to ensure that operations inside the container comply with permission requirements. For example: FROMimage_name#CreateanewuserRUNuseradd-ms/bin/
How to use Java8 Time API
Apr 28, 2023 pm 12:25 PM
1. Overview As part of this article, let us start with some problems with the existing Date and CalendarAPI and explore how the new Java8Date and TimeAPI solve these problems. We will also take a look at the core classes in the Java8 time class library, such as LocalDate, LocalTime, LocalDateTime, ZonedDateTime, Period, Duration and their APIs. 2. The problem of thread safety of the old time API (before Java 8)-Date and Calendar classes are not thread-safe, making it difficult for developers to debug concurrency problems of these APIs and need to write additional code to deal with them.
How to obtain and convert time in Python time module
May 13, 2023 pm 12:19 PM
Pythontime module time acquisition and conversion Python's Time library can perform time-related processing, such as accessing the current date and time, outputting time in different formats, and waiting for a specified time. 1. Get the time 1.1. Timestamp importtimetimestamp=time.time()#1682737552.5009851 Greenwich Mean Time (GMT) The total number of seconds from 00:00:00 on January 1, 1970 to the present 1.2. Structured time importtimestruct_time= time.localtime()#time.struct_time(tm_year=2
What is the difference and usage between time and datetime in python
May 02, 2023 am 11:01 AM
1. Two ways to represent time in Python: timestamp: offset in seconds relative to 1970.1.100:00:00, unique time tuple struct_time: a total of 9 elements>tm_year: year 1-12> tm_mon: month 1-12>tm_mday: day 1-31>tm_hour: hour 0-23>tm_min: minute 0-59>tm_sec: second 0-59>tm_wday: week 0-6 (0 means Sunday)>tm_day: Day of the year 1-366>tm_isdst: whether it is daylight saving, the default is -1.ti
How to solve 'undefined: time.After' error in golang?
Jun 25, 2023 pm 05:28 PM
Golang is a very popular programming language. Its easy-to-learn, efficient and fast features attract more and more developers. But during use, you will inevitably encounter some problems and errors. For example, when using the After method in the time package, you may encounter an error of undefined: time.After. This article will introduce how to solve this error. Understand the cause of the error In Golang, if we use an unexported function name or incorrect
Use the PHP function 'time' to return the current UNIX timestamp
Jul 25, 2023 pm 04:42 PM
Use the PHP function "time" to return the current UNIX timestamp. The UNIX timestamp refers to the total number of seconds since 0:00:00 on January 1, 1970 Coordinated Universal Time (UTC). In PHP, you can use the built-in function "time" to get the current UNIX timestamp. This article explains how to use this function and provides corresponding code examples. Code example: <?php$timestamp=time();echo" current
Detailed explanation of time package based on Go language
Jul 21, 2023 pm 01:27 PM
time.Now() returns a Time type. Sometimes others give us a timestamp, and we need to reverse it as follows, timestamp-time type. What you need to use is time.Unix.
