TyCamTech.com

Introducing the new FfvB Facebook Fan Page!

Please take the time to become a fan and share your experiences, feedback and suggestions. FfvB initially started out with just one idea, to be able to ignore a user's threads as well as their posts and has since grown to become a complete set of tools thanks to users like you!

You can also see what we're working on for future releases and share with others your tips for making FfvB work most efficiently for you.

Join now, and contribute to the future of FfvB!

If you've done enough projects, chances are you've had some pretty big table join queries getting a wide range of data from various tables all one time. For the most part, this has never been a problem and shouldn't be a problem still... if you keep one thing in mind; order matters!

It happened to me and so I hit google, the #cakephp chat room, text books and more and found no real concrete answers but I also discovered that a lot of people are experiencing this issue after upgrading MySQL to version 5.

The issue arrises due to CakePHP's auto joining tables using the Model relations that you specify in the model files being joined after you add your own joins to the query you wish to run. That means that if you make a query, include 2 table joins in the query, it'll join those tables and THEN go to the model and find any relations to also join. This may result in a join trying to access a column's information before the column's table has been joined and thus, throwing an error.

There are a couple of ways to avoid this...

It's fairly obvious where the term Style Sheets may come from since CSS is essentially a tool for styling the content on a website. It's general purpose is to take the images, text and other stuff on a page and style them such that it looks nice and works well in terms of navigation and flow.

But why did they add 'cascading' to the title? Once you learn why, and get used to it, you'll be very very glad they did!

I spent many hours searching and asking in chat rooms and Cakephp's site and just banging my head against the desk on this one...  how in the world do you limit a pagination queries results to x number per page and y number in total??

I wanted to display the top 1000 results out of 1850 or so that I had in the database and show 20 per page.

It seems like a pretty simple problem on the surface but if you try it, you'll see how frustrating it can be. As I said, no one had an answer!!

It wasn't until I stopped, sat down and had some lunch that it dawned on me... the simple problem, had a simple solution!