Re: No rubbish, just looking for straight advice
It depends on what your goals are. A great book that is pretty thorough about addressing many necessary assets of playing is John Petrucci's Wild Stringdom. It'll walk you through good warm ups to increase your flexibility and work on picking speed. If you do exactly as he says in this book, your technique will take off as well as your ability to incorporate that technique in theory. For scales modes and chords, I keep the handy Guitar Grimoire around. Sweet book a more experienced guitar player gave me once, and it's a resource of infinite value.
DVD-wise, for technique stuff, Paul Gilbert has good ones, and although his style is not my taste, Michael Angelo Batio knows what he's talking about in his speed kills series. If you're looking for something to learn tunes or do mode and scale studies from the Lick Library series is really good (everything from Steve Vai, Satch, A7X, Phrygian Mode, Lydian Mode, ACDC) all kinds of stuff available there, but they are expensive. The guitarists who put out those DVDs are quite good though, I know I've been pleasantly surprised when I put one in and it's a lesson from Guthrie Govan.