stuck on 1 shell variable, not re-updating.

[Louie Miranda <lmiranda@gmail.com>]

#!/bin/bash
GEN=`pwgen --no-capitalize -N1`
for i in $GEN
do
echo "update dump set random= '$i'"|mysql -uroot insert
done

--

I have created this shell script, it updates a specific table on a
mysql db. Now, the pwgen is a random password generator. When i run
this program, it only gets 1 variables on all of my fields on the
mysql.

How can i make $GEN to re-calculate everytime it loops? so it can get
a new random password?

-- 
Louie Miranda