acctman Posted April 21, 2010 Share Posted April 21, 2010 $res = @mysql_query("SELECT *, DATE_FORMAT(m_lld,'%m/%d/%y') AS m_lld_formatted FROM social_members LEFT JOIN social_member_types ON t_id=m_type WHERE m_user='".$en['user']."'"); I need to add and INNER or UNION to the query to that I can grab all the fields from social_mcouple IF m_type = 2 THEN social_members.m_id = social_mcouple.c_id and grab all fields. Can anyone assist me, thanks Link to comment https://forums.phpfreaks.com/topic/199318-inner-union/ Share on other sites More sharing options...
fenway Posted April 23, 2010 Share Posted April 23, 2010 Huh? Link to comment https://forums.phpfreaks.com/topic/199318-inner-union/#findComment-1047063 Share on other sites More sharing options...
Ken2k7 Posted April 23, 2010 Share Posted April 23, 2010 Try asking again with the premise that we, the readers, are not psychic. It helps to tell us what you're trying to accomplish rather than stating you need to use INNER or UNION. How the heck would we know if we don't know what you're trying to do? Link to comment https://forums.phpfreaks.com/topic/199318-inner-union/#findComment-1047073 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.