Thanks, Alex!!!
I guess I overlooked the appropriate MySQL documents!
Yea...in terms of the LINKS SQL connection, I had to add some codes in the sub connect routine to allow connections to multiple databases...this, however, did not work when I tried deleting related records across different tables and databases, so I added the db.table reference and it worked!
The weird thing is that in front-end scripts like my delete user account feature, I've had to use the undef... codes and they worked...as you can see, I remmed out those codes in the sub delete_records routine since they didn't work...
Thanks for the input about security...I have the admin script password protected both via sub authentication via LINKS SQL and .htaccess...double protection doesn't hurt.
I also have secondary indexes on all tables posted above...so, that has helped in terms of data processing. I just wanted to double check to see if there wasn't any better codes that I could use.
thanks!
Regards,
Eliot Lee
I guess I overlooked the appropriate MySQL documents!
Yea...in terms of the LINKS SQL connection, I had to add some codes in the sub connect routine to allow connections to multiple databases...this, however, did not work when I tried deleting related records across different tables and databases, so I added the db.table reference and it worked!
The weird thing is that in front-end scripts like my delete user account feature, I've had to use the undef... codes and they worked...as you can see, I remmed out those codes in the sub delete_records routine since they didn't work...
Thanks for the input about security...I have the admin script password protected both via sub authentication via LINKS SQL and .htaccess...double protection doesn't hurt.
I also have secondary indexes on all tables posted above...so, that has helped in terms of data processing. I just wanted to double check to see if there wasn't any better codes that I could use.
thanks!
Regards,
Eliot Lee