Hey guys, This is my first proper php app. so be nice
I have a mysql_query that joins a two tables, it's working properly, but I want to add one extra variable with the results.
$topRanked = mysql_query("SELECT * FROM news JOIN users ON news.Username = users.Username WHERE users.connected='$yourname' ORDER BY created DESC") or die(mysql_error());
How this works is, I have 2 tables, one containing news stories and one with users...the users can be linked with one another, therefor you see their story.
This part works GREAT, but the user doesn't see his own stories.
Currenly it's getting every news story, except the users news story...how can I modify the QUERY that it also includes the users news stories?