heres the code i am working with:

And now the problem:
When the page index.php?op=add loads the first time the data in the form is empty. If you type in data in the form and press submit the data is entered into the database like is should and the page is redisplayed as the for action is to the same page. When the page is redisplayed the form is there ready to be used again. Now this second time if you enter new data again and press submit it will display the "not set" echo thats in there and no data will be inserted into the database. Now after the second attempt and the "not set" displays if you hit f5 (page reload) then the second set of data is sent proper like and is put in the database. How do I avoid having to hit reload with the second set of data?

use the Php header() function of the XOOPS redirect_header() function (see it in include/functions.php) to redirect user to another page or to the same page.

Two notes :
1/ Use the XOOPS API to talk with the database (use the database object), and never use, directly, the MySQL functions, for example :


2/ Use the sanitizer before to use external data (especially coming directly for the user) in your sql queries.
What you are doing actually is dangerous and there as some security issues.
Use the XOOPS MyTextSanitizer object, for example :

Quote:

Finally, I suggest you to use the XoopsObject, everything we discussed is inside it, and buy a good book about Php.

Take the code of a module an study it.

So use MyTextSanitizer and query like this?

Yes that is good!

You can also use $db->prefix('names') instead of xoops_names,