INER JOIN first time writing

[ebchost]

I write first time INER JOIN and i have error

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

 

this is the query

<?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());

?>

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

[gristoi]

your trying to get a  field called post.id. but you stated your table name is postos. Is that a typo on the forum or a typo on your table name?

[ebchost]

your trying to get a  field called post.id. but you stated your table name is postos. Is that a typo on the forum or a typo on your table name?

 

typo mistake an the forum

 

thanks,

 

now is corect

and,

in my DB structure i have 2 tables:

1. categories - id, name,

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