As described, exactly what happens when battery is flat.
There may be enough energy in the battery for lights, but not enough to power the starter motor.
Solution- put the battery on charge for 12h, or you may need to replace it.