Select and Print?

[MtPHP2]

Okay here I go! I want to print 'user' and 'message' from a MySQL table called 'instantmsgs'
So if I have in my table
user: user000 message: message000
user: user111 message: message111
I would want it to print
user000: message000
user111: message111
how?
Notice how oldest is posted first...
Thanks in advance for any help!

[fitchn]

In order to do this, you will need at least one other field in your MySQL table: a date/time stamp. Then, simply SELECT the desired results from the table, using ORDER BY and DESC on the date/time stamp field, like so:

SELECT * from instantmsgs ORDER BY <date/time stamp field> DESC

That should do it! Hope that helps!

• Nick

[MtPHP2]

I got that working great, thanks!
The thing I have now though, is I want it to print
user000: message000
user111: message111
It just prints
user000: message000
with the code
[PHP
print $row['user']; print ": "; print $row['message'];
[/code]
How can I fix this? THX.