Gilead - 6:33 pm on Nov 7, 2011 (gmt 0)
yes, I found the PO, unfortunately, that wasn't the problem. You may be onto something about not having the privileges. I've emailed support to find out. Works fine under phpmyadmin
In this case the id is not numeric, but the member's id number; the data is alphanumeric and has both upper and lowercase as well. I chose that for the primary key since each is unique, unlike their account number which can be the same within the same company.
Just looked at the mysql user, all privileges are set.
I'll give the check a try. Once working, I'll sanitize the input. Thanks!
Will keep you up to date.