Here is the word doc which I put together after we went through the process of creating this over the phone. This is what I'm following, and it's not working. However, this was done using MySQL, not MySQLi. I upgraded it, so maybe the processes need to be tweaked?
Thanks.