Man in hospital after drive-by shooting