RE:[2] Complex Left Join

2001-12-20 Thread Brian E . Lozier
t works? That's what beta testers are for. I only coded it." - Linus Torvalds - Original Message - From: Simon Green <[EMAIL PROTECTED]> To: "Mysql (E-mail)" <[EMAIL PROTECTED]> Date: 12/20/01 2:30:43 AM > >Can OPTIMIZE help at all? > >Simo

Complex Left Join

2001-12-20 Thread Brian E . Lozier
I'm trying to accomplish something a bit complex with a single query. Basically, I'm doing a nested category/file listing, and I want to get the number of categories and the number of files under each category in the list. For example: http://www.massassi.org/saberworks/files.php user: kedri

MySQL Data problem...

2001-09-01 Thread Brian E . Lozier
Well I made quite the mistake and I'm hoping someone can help me out! I had a RH Linux 6.1 box running MySQL (not exactly sure what version anymore). I took all the files from the mysql/data directory and backed them up. Then I wiped the server and installed FreeBSD. I then installed the l