Why would blob be any more secure than anything else? If encryption isn't enough, you're not using the right encryption. :) -Micah On Sunday 14 March 2004 05:18 pm, Ng Hwee Hwee wrote: > hi all.. > > thank you so much for your help! > > i tried out the all the different syntax and the following works perfectly > > SELECT * FROM `MEMBER` WHERE `PASSWD` = "" > > thanx, amanda! > > btw, i was trying to store the encryted password in the database but i do > not want anyone who has the right to see the database (even myself!) to be > able to know the password, so that there is maximum 'security'. That's why > i used the blob field for my password.. hmmm... is this the right way of > doing things? > > hwee -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php