Doesn't seem to work, how would I print that out with PHP?
On Monday 19 March 2001 13:52, you wrote:
how about something like
select distinct
name,
date_format(time, "%W %D %M %Y") as login
from
users, user_logins
where
user_logins.user_id = users.id
order by
The php below illustrates how to print database results from
mySQL in PHP. Apologies for the long post.
You should be able to extrapolate from here - ie this is
generic, you will want to keep track of the usernames and
only print them when they change. Dont forget to print the
last one if you do
how about something like
select distinct
name,
date_format(time, "%W %D %M %Y") as login
from
users, user_logins
where
user_logins.user_id = users.id
order by name,time
-Original Message-
From: Jordan Elver [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19,
Doesn't seem to work, how would I print that out with PHP?
The results will come back sorted by name, then time. While processing each
row, you'll need to keep track of when the username changes, something like
this (this is just rough code, not quite valid PHP):
$username = '';
while
