shell script problem

[piti]

hi
i'm stuck and need some shell scripting expert
what i want to make is a script where i select data from my mysql database and for every returned record run another script with the record fields as arguments

i have that mysql part done:
mysql -u piti -ppiti -D testdb -e "SELECT IdCK, Preset FROM CKTbl WHERE IntOpen = 1 " -N -s

but the other one, run the second script, i'm not able to accomplish
any idea how to do that?
thanx

 

[zebedeee]

As I'm a bear of very little brain, I'd start by saving the output of the mysql bit into a text file - assuming 1 line per output record. Then, using you favourite scripting language (which I'll assume is Bash), open the text file as an array and use

foreach ($line @array){
/* Whatever code you want to run on each output line */
}

Okay, so this is perl, not bash, but there can't be that much difference.