ebchost Posted June 14, 2011 Share Posted June 14, 2011 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 More sharing options...
gristoi Posted June 14, 2011 Share Posted June 14, 2011 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? Link to comment https://forums.phpfreaks.com/topic/239319-iner-join-first-time-writing/#findComment-1229462 Share on other sites More sharing options...
ebchost Posted June 14, 2011 Author Share Posted June 14, 2011 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 Link to comment https://forums.phpfreaks.com/topic/239319-iner-join-first-time-writing/#findComment-1229464 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.