Welcome Guest, Not a member yet? Register   Sign In
Can't retrieve all records from database [SOLVED]
#6

[eluser]alrightythen[/eluser]
[quote author="andrewtheandroid" date="1257457192"]ahh ok yeh i was reading up on joins for my current project a few hours ago actually. i needed to join 3 tables. I was reading
This

Could it be your case is one of those examples mentioned?[/quote]


Ugh ok it finally works! Thanks andrew.

So I did a left join that would display all unmatching rows and I had NULL values in the joined fields. I joined on the wrong fields
instead of subcat_ID = profile_ID I'm suppose to join on subcat_ID = profile_SubcatID

Thanks again andrew


Messages In This Thread
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 08:51 AM
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 09:04 AM
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 09:25 AM
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 09:39 AM
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 09:56 AM
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 09:57 AM
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 10:00 AM
Can't retrieve all records from database [SOLVED] - by El Forum - 11-05-2009, 10:01 AM



Theme © iAndrew 2016 - Forum software by © MyBB