Simple JOIN problem in a SELECT statement

[ifis]

Hey guys, I'm having trouble with joining two tables in a SELECT.  Here is the code:

$sql = "SELECT*FROM member JOIN blog";
$result=mysql_query($sql);		
while($row = mysql_fetch_array($result)){
    echo" <tr>
          <td><h3>$row[firstName] $row[lastName]</h3></td>";
    echo "<td>$row[Date]</td>
          <td>$row[Title]</td>
        </tr>";
		}
    echo "</table>";

I get the error:Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource.

Any ideas?  I'm sure it is something simple that I am just missing.  Thanks.

[chantown]

JOIN ___ USING(id);

[ifis]

Not totally sure what you mean:

JOIN ___ USING(id);

do you mean somthing like

"SELECT*FROM member JOIN blog ON member.id=blog.id"

?

[revraz]

A JOIN links two tables with some type of field, usually and ID field.

 

Maybe you want a UNION?

 

What is stored in the two tables and what are the field names.  Which one is the field that links them.

[ifis]

I figure it out.  I was not capitalizing correctly.  So it ended up working with:

$sql = "SELECT*FROM blog JOIN Member ON blog.loginName = Member.loginName ORDER BY date DESC";

thanks for all the help