chilli

Ok so I know it's a car forum, but some of you might be able to help, I hope! I need to run a query that has many individual parts, but they need to be treated as a whole set on multiple rows. Greately simplified, something like this: Query is something like 'get me all rows as a whole group that match the clause conditions' where there are clauses like this: ((q = 3) and (v 6)) from a table something like: id g q v 1 1 1 3 2 1 2 2 3 1 3 4 4 1 5 8 5 1 6 1 1 2 1 3 2 2 2 2 3 2 3 6 4 2 5 8 5 2 6 1 ... which should work like this. for group g = 1, q = 3, v 6 is valid, so return me all rows for g = 1 for group g = 2, q = 3, v 6 is bot valid, so don't return me all rows for g = 2 and so on... so the result would be in this case id g q v 1 1 1 3 2 1 2 2 3 1 3 4 4 1 5 8 5 1 6 1 as only group 1's rows match _all_ the clause conditions as a complete set. the only way I can think to do this is to create a pivot table and put all the q values as columns and then I can run a normal query that tests q3>x and q5 so that leads me to my question anyone know how to do a generic pivot in mysql (5.x) or know another way to solve this (maybe using stored procs)? any help greatly appreciated, I'll carry on muddling through in the mean time hoping for a brainwave!

lol, you're a bad man

what an idiot, another Darwin awards entry coming up I think

ahhh no this was on the A27 goes from Lewes towards Brighton

I really like spaced, shame they didn't make more though. For some reason that quirky humour reminds me of Black Books also, another good series if you can get into it

I just found one of these mintrels and come on here to check out what it is! I took it out, but now I'm putting it back in. Does it have any other purpose?

I think it's Glucosamine that helps with joints isn't it? Might be worth looking it up.

The gf saw you for a split second, I heard you and you were off! Didn't see you again for the rest of the journey into Brighton!

Saw you today at about... 1pm in the car park for M&S. It was looking good!

omg, I didn't realise that was the uk entry, ffs how embarrassing lol. For a while I'm ashamed to be British, that's possibly the most cheesy song I've ever heard lol, I need another drink after that!

The ones where they offer to sort out all your debts by lending you 20k, but you have to pay them back something stupid like 80k. I can't help but think that the people that take those sort of loans on are never going to be out of debt, ever!

Do you still have any Jspec brake pads left?

This one, for sure. And who keeps pens and paper in the loo?

We should, but we don't sadly.

If you tried to speak to any of the kid's parents around here, you'd get a mouthful! It's nice to see that you care though. If you went and asked the parents where their kids were at that moment, I bet they couldn't tell you.

The gf has said she has seen you a few times on the way to work in the mornings. Anyone on here?

This is Bo. She's gorgeous, stupid most of the time, but really quite clever at the same time. She's got a bell on her collar so you always know where she is.

for all us home owners, now might be a good time to sell up cash in, rent for a few years and buy when the prices hit rock bottom however no one can truly predict a crash, people were saying there might be one 6 or 7 years ago when I was looking and I nearly held off, so glad I didn't as they then climbed more, to the point I wouldn't have been able to afford what I wanted at the time! you always do ok out of property if you can be in it for the long term and ride out the hard times interest rates are still low, relatively speaking. If you're feeling the pressure at 5.5% me thinks you've stretched too far already anyway

If you want new tyres, I received good service and great prices online from: http://www.tyrexpress.com - email [email protected] -- If you want someone in the Sussex area you can trust to fit tyres with care, try Able tyres: Speak to Martin, his number is 01825765944 32 Bell Lane, Bellbrook Ind Est, Uckfield, East Sussex, TN22 1QL 01925 657 070

so that does work out around 1875pm take home then? (29500 - 7000) / 12 = 1875 not bad actually, think yourself lucky you're not in the high tax bracket, that hurts a lot!

agreed, I'm on more still than 32k and it doesn't top out that much more net by the time you've factored in friggin tax and NI from memory, when I used to earn 30k something like 16-1700ish net pm may be about right after all deductions, does depend on your tax code etc and if you touch into the b@stard 40% tax bracket too (you should be ok with that)

do love the ultima gtr would love to own one, one day. get it and build it yourself = save lots can't imagine it's too comfy on the roads though lol so if you want purely a fast track car, you could make something nearly as quick for less I'd suspect as a road legal car they are fantastic vfm. But if they are only road legal but not road practical then that kinda does detract from their appeal. After all there is the radical SR8 if you want to go mentally fast around a track... so the ultima should really be road usable as well as legal (which is I guess what you're asking and I just don't know, never been in one) probably comes down to what you can put up with if you want the car that much

hmmm no debt on my car(s) no loans approx half equity in my house but I'm finding myself running half a months salary into my overdraft at the moment (but there has been a lot to pay out for recently on home improvements and other things). To think I was feeling bad about that too. Sorry I can't cheer you up though.

I've got them both now, thanks everyone.

I think they must have changed the seat design then in the latest models, not found that problem, in fact surprisingly nice seats for a standard car