Web Design Forum: JOIN - Web Design Forum

Jump to content

WDF
WDF Premium Memberships Reseller Hosting
Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

JOIN mysql Rate Topic: -----

#1 User is offline   lee sands 

  • Dedicated Member
  • PipPip
  • Group: Members
  • Posts: 134
  • Joined: 14-August 10
  • Reputation: 0
  • Gender:Male
  • Location:Gosport, Hampshire, UK
  • Experience:Beginner
  • Area of Expertise:Coder

Posted 14 January 2012 - 07:21 PM

Hi All i am having problems with join

baiscly i have 3 tables

cms_articles
cms_users
cms_catergories

now i am trying to list all items with the catergoy id (cat_id)

now i also need to show first and lastname's insted of author_id any help would be nice
0

#2 User is offline   webdesigner93 

  • Web Guru
  • PipPipPipPipPip
  • Group: Members
  • Posts: 1,976
  • Joined: 22-September 09
  • Reputation: 222
  • Gender:Male
  • Experience:Web Guru
  • Area of Expertise:Web Developer

Posted 14 January 2012 - 09:09 PM

View Postlee sands, on 14 January 2012 - 07:21 PM, said:

Hi All i am having problems with join

baiscly i have 3 tables

cms_articles
cms_users
cms_catergories

now i am trying to list all items with the catergoy id (cat_id)

now i also need to show first and lastname's insted of author_id any help would be nice


mmm 
WHERE `cat_id` = '$cat_id'


and if the first and lastname is in the tables then just display them like u would any other data
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users