Can't retrieve all records from database [SOLVED] |
[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
|