• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
join querys

#1
[eluser]Unknown[/eluser]
:question:




i have an issue for joining three tables i'm confused with left and right joins and also the inner join ..
i have three tables namely new_item_adding,friends and userdetails
new_item_adding has the following fields:`id`, `user_id`, `category`, `Create_Item_Link`, `size`, `Est_Value`, `Brand`, `style`, `Purchase_Date`, `buy_it_now`, `regi_input_size`, `Handbag`, `Dress`, `Accessories`, `add_date`, `group`, `status`.
friends has the following fields:`id`, `requestFrom`, `requestTo`, `status`, `createdBy`, `createdDate`
and userdetails has the following fields:`id`, `username`, `fname`, `lname`, `password`, `passconf`, `email`, `photo`, `address`, `city`, `state`, `zip`, `cc`, `exp`, `cvv`, `dob`, `size`, `favBrand`, `myStyle`, `aboutMe`



i need to access the details of userdetails who are my friends and the new items they have added in new_item_adding table

#2
[eluser]TheFuzzy0ne[/eluser]
Welcome to the CodeIgniter forums!

Google is your friend. No point asking us to reinvent the wheel. We have better things to do. Smile

http://www.keithjbrown.co.uk/vworks/mysql/mysql_p5.php


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.