On a project I am doing I am making a Feed Flow of recent updates. Problem is I cant find out to overcome the following.
There are two tables, shouts and journals. what I want to do is pull records from them both and print them out with the newest at the top and the oldest at the bottom.
I have tried every way and cant find how to do it, but heres the logic of what I am trying.
The two tables fields are
shouts = id, content, date, user
journals = id, content, title, date, user
SELECT * FROM shouts, journals ORDER BY id DESC;
While( $row = above statement )
{
if its a shout
{
print "Shout: $row";
} else {
print " Journal: $row <br> $row";
}
The final result of the flow should be something like
SHOUT
SHOUT
JOURNAL
SHOUT
JOURNAL
ect ect but at the moment all I can seem to get working is all journal or all shout
Any help Highly appreciated.
}