I don't think you should try to convert the UNIXTIME to a DATE format.
Just take time() minus the joindate from the table (in UNIXTIME) and subtract them and divide by the number of days in seconds to get the number of days. No need to convert to DATE format.
Or whatever you like, but your query is broken... try again
PS: There is no field in the user table called "jointime" as in your original query. Please check your table definition. Hint:
Code:
mysql> select joindate from user where userid =1;
+-----------+
| joindate |
+-----------+
| 968947200 |
+-----------+
1 row in set (0.00 sec)
Today I mapped out the new badging system using FA icons, Beta 1 in no particular order except a 6 x 8 grid:
https://www.unix.com/members/1-albums215-picture991.png
The prototype HTML code for this layout:
<style>
.fa-badge-grid {
font-size: 1.5em;
}
.row {
... (38 Replies)
Dear All,
Here is the current status of the badging system:
The Beta 1 phase of the new badging system is close to completion.
42 prototype badges have been "allocated"
6 prototype badge slots are held in reserve
The "alert you have new badges" prototype is running and is currently... (4 Replies)
I have moved the bug badge out of reserve and into the main stream. Basically, I will assign a color level like the others, based on who has made a good actionable bug report for UNIX.COM. "Good" means screenshots, links, and even details from web dev tools our the HTML source code. So far,... (0 Replies)
Discussion started by: Neo
0 Replies
LEARN ABOUT PHP
udm_find
UDM_FIND(3) 1 UDM_FIND(3)udm_find - Perform searchSYNOPSIS
resource udm_find (resource $agent, string $query)
DESCRIPTION
Performs a search.
The search itself. The first argument - session, the next one - query itself. To find something just type words you want to find and press
SUBMIT button. For example, "mysql odbc". You should not use quotes " in query, they are written here only to divide a query from other
text. mnoGoSearch will find all documents that contain word "mysql" and/or word "odbc". Best documents having bigger weights will be dis-
played first. If you use search mode ALL, search will return documents that contain both (or more) words you entered. In case you use mode
ANY, the search will return list of documents that contain any of the words you entered. If you want more advanced results you may use
query language. You should select "bool" match mode in the search from.
PARAMETERS
o $agent
- A link to Agent, received after call to udm_alloc_agent(3).
o $query
- mnoGoSearch understands the following boolean operators: & - logical AND. For example, "mysql & odbc". mnoGoSearch will find
any URLs that contain both "mysql" and "odbc". | - logical OR. For example "mysql|odbc". mnoGoSearch will find any URLs, that
contain word "mysql" or word "odbc". ~ - logical NOT. For example "mysql & ~odbc". mnoGoSearch will find URLs that contain word
"mysql" and do not contain word "odbc" at the same time. Note that ~ just excludes given word from results. Query "~odbc" will
find nothing! () - group command to compose more complex queries. For example "(mysql | msql) & ~postgres". Query language is
simple and powerful at the same time. Just consider query as usual boolean expression.
RETURN VALUES
Returns a result link identifier on success or FALSE on failure.
PHP Documentation Group UDM_FIND(3)
01-01-2019
