I have my current query,
[php:1:361fd80a66]<?php
$query = \"SELECT id,title,newstext,\" .
\"DATE_FORMAT(postdate, \'%Y-%m-%d\') as date \" .
\"FROM news ORDER BY postdate DESC\";
?>[/php:1:361fd80a66]
but i need to also add a poster_id to the news table query and join that with a users table with an id and username. If i remember correctly i just have to add the table name and a period before the field, but how do i do it for the postdate?
Also, when I go to output the username from the users table in PHP, do i have to do $row[username], or will i have to do $row[users.username]?
any help is appreciated since i am new to table joins.