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
dbx_fetch_row
DBX_FETCH_ROW(3) 1 DBX_FETCH_ROW(3)dbx_fetch_row - Fetches rows from a query-result that had the DBX_RESULT_UNBUFFEREDflag setSYNOPSIS
mixed dbx_fetch_row (object $result_identifier)
DESCRIPTION dbx_fetch_row(3) fetches rows from a result identifier that had the DBX_RESULT_UNBUFFERED flag set.
When the DBX_RESULT_UNBUFFERED is not set in the query, dbx_fetch_row(3) will fail as all rows have already been fetched into the results
data property.
As a side effect, the rows property of the query-result object is incremented for each successful call to dbx_fetch_row(3).
PARAMETERS
o $result_identifier
- A result set returned by dbx_query(3).
RETURN VALUES
Returns an object on success that contains the same information as any row would have in the dbx_query(3) result data property, including
columns accessible by index or fieldname when the flags for dbx_query(3) were set that way.
Upon failure, returns 0 (e.g. when no more rows are available).
EXAMPLES
Example #1
How to handle the returned value
<?php
$result = dbx_query($link, 'SELECT id, parentid, description FROM table', DBX_RESULT_UNBUFFERED);
echo "<table>
";
while ($row = dbx_fetch_row($result)) {
echo "<tr>
";
foreach ($row as $field) {
echo "<td>$field</td>";
}
echo "</tr>
";
}
echo "</table>
";
?>
SEE ALSO dbx_query(3).
PHP Documentation Group DBX_FETCH_ROW(3)
01-01-2019
