I want to create audio files dynamically based on the query results. Database Query module as follows:
SELECT time_ref FROM restourant WHERE restourant_code=$RV[GET RESTOURANT CODE] and reservation_status=0 and min_pax<=$RV[GET RESERVATION COUNT] and max_pax>=$RV[GET RESERVATION COUNT]
Query results (time_ref variable) can be between 1 and 7. Query may return multiple data. Play Module will change according the query results. Of course, I do not know the number of records returned.
Only one record return, time_ref variable = "3", sound file to play = "\time_3.wav"
Two record return, time_ref variable = "4" and "5", sound file to play = "\time_4.wav,\time_5.wav"
four record return, time_ref variable = "1","3","6" and "7", sound file to play = "\time_1.wav,\time_3.wav,\time_6.wav,\time_7.wav"
Please help me. Is it possible to make in Evaluate Expression module?
I've got another question. Can I use "group by" function in Database Query Module?