hi all. newbie php questions here. i have a basic understanding of how to use xoopsDB. I'm currently trying to write a script to clean up my database and i'm getting the error,

Quote:

i have the following on my index.php page,

Quote:

and this is what clean.php looks like,

Quote:

so i guess my question is, how the heck do i execute this query? is it not proper to do it as an include or am i just using xoopsDB incorrectly?

thanks for any tips.

$xoopsDB->query( $sql ) will only execute:
1. when the sql statement is a 'select' statement or
2. when the insert/update/delete statement is coming from a $_POST request.

This is for security, so that $_GET requests are only able to 'view' data, not perform updates on the database.

To make your code work you need to either call the script using a POST request, or force the update by using $xoopsDB->queryF( $sql ). It's your choice which to use.

If you want to convert a GET request to POST you can use the confirmation page. This page is submitted as a POST request, which then allows the sql statement to be executed.

e.g.


If you don't want user interaction then use queryF.