Thank you - this helps a lot - its good to also know that the SQL problem I was having is a mySql thing - not me !!!!!
That may be true, I not too sure though. You never did disclose how you are using Perl to build the SQL command and send it to the MySQL server. If you were to take this same question to a MySQL group you would surely be flame bate. I would not be thanking the person that told you this was a MySQL problem.
> > SELECT name, email, password, username FROM members WHERE > email='[EMAIL PROTECTED]'; > > BUT - it really doesnt like this, any ideas why ???
I have no problem executing this statement in MySQL, from command line mysql, from Webmin's MySQL Database server, or strict Perl.
You need to form this in a new question giving us details about your table "members" and what method you are using to access your MySQL server, script examples like you did with the prior question and any error messages you may have encountered.
Your query is sound, I don't know of any SQL server that would choke on it, definitely not MySQL.
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]