Jump to content

kalel2

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

kalel2's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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.
×
×
  • 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.