hi the error is in this line: $newvalue = $row["Password"]; make it $newvalue.= $row["Password"]; (notice ^ the dot - for concatenation with the previous value).
and if u want to see each password in the browser too, in that same loop, put: echo "{$row["Password"]\n"; so it would now look like: while ( $row = mysql_fetch_array($rows1) ) { $newvalue.=$row["Password"]; echo "{$row["Password"]\n"; } u may also want to use a <br> in ur echo line to make the browser output nicer, the \n affects only the html code. and while u're at it, put a \n in $newline so that ur email looks nicer. abs ________________________________________________________________________ BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st December 2003. The way the internet was meant to be. http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]