03 Altima 2.5 won't start but turns over. Battery drained and headlights come on

Hello, The headlights coming on is certainly strange, but it could be a result of the battery draining. Low power conditions do strange things to electronically controlled systems. Charge the battery, attempt to start, and use a code reader to find any stored trouble codes. I am not saying this is for sure the cause, but older Nissans are always having issues with cam and crank position sensors, so make sure they are sending signal to the PCM.