Jump to content

INER JOIN first time writing


ebchost

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/239319-iner-join-first-time-writing/
Share on other sites

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.