stuck on 1 shell variable, not re-updating.

[Louie Miranda]

#!/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


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]