BetterPHP

I write first time INER JOIN and i have error

Unknown column 'posts.id' in 'field list'

this is the query
[syntax=php]<?php
$query = "SELECT posts.id AS post_id, categories.id AS category_id,
title, contents, date_posted, categories.name
FROM posts
INER JOIN categories ON categories.id = posts.cat_id";
mysql_query($query)or die(mysql_error());

?>[/syntax]
and,
in my DB structure i have 2 tables:
1. categories - id, name,
2. postos - id, cat_id, title, contents, date_posted

wer is the problem?

thanks

are you sure the posts table has the column id, and not ID or something else.

Copy/paste header from php my admin
posts:

id cat_id title contents date_posted

categories:

id name

hostingebc wrote:in my DB structure i have 2 tables:
1. categories - id, name,
2. postos - id, cat_id, title, contents, date_posted

wer is the problem?

thanks

UPDATE for secon table name

2. posts: id, cat_id, title, contents, date_posted

hmm it does seem that you have a column called that.

you could try quoting the table and column names with backticks `

Your table is postos, but you specify you're selecting from the posts table.

That's your problem