Another rewrite for my Lonely Hearts Column dating site
It’s time for my 6 monthly rewrite for my dating site. I feel I’ve really gone to town this time 
Not only have I flattened loads of bugs, I’ve redesigned the look and even gone to the expense of commisioning some artwork.
I’ve also rewritten loads of the database queries as I’m now using MySQL 4.1.x - my old host (yes I’ve changed hosting providers as well) was on 4.0.x and didn’t have any plans to upgrade when I asked them a few months back, so now I can use sub queries
Now all I need is a ton of traffic. Let me know what you think of my updated lonely hearts personals site
Very cheezy — fits well! Watch out for your character sets ma boy, since “�” generally means something couldn’t be converted. I can give examples but I won’t here.
Sub-queries are evil, so be careful. I’m not sure about MySQL’s implementation, but there’s a very high chance that they will cause several “inner” result sets to be created for every real row you return. Personally I haven’t hit a problem that required sub-queries because joins wouldn’t work, nor have I ever seen sub-queries used in a query that can outperform its equivalent using real joins.
Prove me wrong!