So I'm building a financial planning site that adds up all sorts of data in all sorts of places, and I believe in some cases sub-queries can make your queries a lot more efficient. So when I built my site on my local box (Mac, os 10.3, php 4.somethin, mysql 4.something, apache2.something) I used sub-queries. When I moved my site to TCH hosting I found they didn't work. So first I'm just wondering why that is, and second, what do I need to do to get up and running? Do I just need to lay low until TCH updates its mysql version? Do I need to adjust my syntax? Do I need to just revamp my code to not use sub-queries? Anyway, I'll further explain what I mean by sub-query to make sure we're on the same page.
For example, the following query is ridiculous but shows what I mean. On my local box I can run the queries like
SELECT * FROM sometable WHERE sometable.blah IN (SELECT blah FROM sometable)
without any problems, but when I run queries like that on TCH I get your standard syntax error.
By the way, I'm new, and I just realized I probably stuck this question in the wrong spot. sorry about that, thanks much.
