Five series of substituted aroylhydrazones having two alkoxy chains at 3- and 5- positions at amide end of the molecule have been synthesized; wherein each series differ from each other in terms of number and position of alkoxy chains at imine end. The compounds of first series with the single alkoxy chain at 4-position at imine end self-assembled into columnar hexagonal mesophase. The lower homologues of the series with alkoxy chains at 3- and 5- positions at imine end showed a transition from columnar hexagonal to columnar rectangular mesophase in cooling cycle while the higher homologues exhibited columnar hexagonal mesophase. The series with alkoxy chains at 3- and 4- positions exhibited columnar rectangular mesophase. All the homologues of series with alkoxy chains at 2-, 3- and 4- positions showed a transition from columnar rectangular to columnar oblique mesophase in cooling cycle. The series with alkoxy chains at 3-, 4- and 5- positions exhibited transition in columnar hexagonal mesophase. The mesophase crossover from one columnar mesophase to the other was found to be dependent on the chain length as well as on the temperature during the self-assembly process in these molecules. The temperature dependent columnar mesophase crossover has been observed for the first time in these systems. The substitution pattern showed an influence on the photophysical properties. The number and position of alkoxy chains played a critical role in the formation of gel in these molecules. These liquid crystalline gelators have application potential in organic optoelectronic functional materials and devices.