SQL JOINS

[son.of.the.morning]

Hey guys, am am creating a blog and i need a little help with some SQL querys. I have a table called "Posts" and there are to coloums that i nees to be related to other tables

 

i.e.

Posts (table)

- Id

- title

- aurthor_id  ---> AUTHORS_TABLE

- category_id  ----> CATEGORY_TABLE

- datePosted

 

I know that i have to use joins but i am unshure on how to create them correctly.

[trq]

This should get you started: http://www.phpfreaks.com/tutorial/data-joins-unions

[son.of.the.morning]

I keep getting a Error "Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\matts_blog\articles.php on line 56"

 

<?php 
	$articles = ("SELECT * FROM blog_posts INNER JOIN users ON blog_posts.author_id=users.id");
	$articles_results = mysql_query($articles);
?>
            
        <?php

	  while($article_rows = mysql_fetch_array($articles_results)){		
?>

[trq]

You really need to check your results before using them. What does mysql_error have to say?

[son.of.the.morning]

It's ok man i found the problem, like always it was a silly spelling mistake.

 

Thanks for you help boss!