Help with Joins!!!

admin

Administrator
Staff member
Why does this query return two results?? There is only one record in the news table!!!

mysql_query("SELECT a.name, a.email, n.title, n.submit_time, n.body FROM news n, administrators a, categories c WHERE n.category_id = c.category_id AND c.category_id = 1")

If you want to see what the two results are, go here: <!-- m --><a class="postlink" href="http://www.zikes.com">http://www.zikes.com</a><!-- m -->
 
Back
Top