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