query problems with joins...

[Anon]

AACK is this correct?

$articleQuery=mysql_query("select ff_date,title,body from
articles (inner join realms on realm) where realms.name like
'article';");

[Anon]

So you have two tables - I'm not sure what the names are...

we'll say table1, and realms

The usual syntax I use is

select table1.field1,table1.field2,realms.field3 FROM table1,realms
WHERE table1.id=realms.id

Does that help?

Did you read the "get started" pages here about how to check for errors on queries?

[Anon]

i should probably add a few things: here is teh original query:

$articleQuery=mysql_query("select ff_date,title,body from
articles (inner join realms on realm) where realms.name like
'article';");

okay here are the db structs for the articles table and the realms table:

mysql> explain articles;
+---------------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------+------+-----+---------+----------------+
| id | int(11) | | PRI | 0 | auto_increment |
| ff_date | text | YES | | NULL | |
| title | text | YES | | NULL | |
| realm | int(11) | YES | | NULL | |
| body | text | YES | | NULL | |
| posted_by_ndx | int(11) | YES | | NULL | |
+---------------+---------+------+-----+---------+----------------+

and realms:

mysql> explain realms;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(11) | | PRI | 0 | auto_increment |
| name | varchar(32) | YES | | NULL | |
+-------+-------------+------+-----+---------+----------------+

anyhow, i need to get each article in the articles table that has a realm of '1' for instance, but i need to reference that via realms.name.

hope this clears up some...

[Anon]

select articles.field2,realms.name FROM articles,realms WHERE articles.realm=realms.id and articles.realm=1;

Again, be sure to check for errors and echo them out.

[Anon]

thanks alot...