Welcome Guest, Not a member yet? Register   Sign In
What's wrong with this code? =/
#6

[eluser]Abel A.[/eluser]
Can you try using regular queries?

my advice for complex queries is to not use active records because it can be hard to read at times and very difficult to analyze.

I'm still confused on what you're trying to do with your query. Comments and articles shouldn't go on the same query. You can query the comments and join it to the user table to get author, and run a SEPARATE query to get the articles and their author by joining the user table again. That would be the best approach.

What exactly do you want to display when the user loads the page?


Messages In This Thread
What's wrong with this code? =/ - by El Forum - 06-06-2012, 12:25 PM
What's wrong with this code? =/ - by El Forum - 06-06-2012, 12:44 PM
What's wrong with this code? =/ - by El Forum - 06-06-2012, 01:26 PM
What's wrong with this code? =/ - by El Forum - 06-06-2012, 01:32 PM
What's wrong with this code? =/ - by El Forum - 06-06-2012, 01:34 PM
What's wrong with this code? =/ - by El Forum - 06-06-2012, 01:44 PM
What's wrong with this code? =/ - by El Forum - 06-06-2012, 01:46 PM
What's wrong with this code? =/ - by El Forum - 06-06-2012, 01:51 PM
What's wrong with this code? =/ - by El Forum - 06-06-2012, 02:08 PM
What's wrong with this code? =/ - by El Forum - 06-06-2012, 02:50 PM
What's wrong with this code? =/ - by El Forum - 06-06-2012, 04:16 PM
What's wrong with this code? =/ - by El Forum - 06-06-2012, 04:22 PM
What's wrong with this code? =/ - by El Forum - 06-06-2012, 05:02 PM
What's wrong with this code? =/ - by El Forum - 06-06-2012, 05:45 PM



Theme © iAndrew 2016 - Forum software by © MyBB