I use $xoopsDB->query() for SELECT, UPDATE, INSERT and adding columns and it works fine. But I tried to delete a column with:

$rec = "ALTER TABLE ".$xoopsDB->prefix('inventory')." DROP COLUMN ".$colname."";

$xoopsDB->query($rec);

And it doesn't work. Any ideas? queryF works ok...

I know the drop syntax is correct because I echo $rec and paste it to mysql's command line interface and it works fine.

Also, after noting the following from the mysqldatabase.php file, how do ANY queries work?

/**
* perform a query
*
* This method is empty and does nothing! It should therefore only be
* used if nothing is exactly what you want done!
*
* @param string $sql a valid MySQL query
* @param int $limit number of records to return
* @param int $start offset of first record to return
*
* @abstract
*/
function &query($sql, $limit=0, $start=0)
{

}

How is it my other queries even work??? What's up with this? What am I missing?

Regards

Doug P

test : $rec = "ALTER TABLE ".$xoopsDB->prefix('inventory')." DROP COLUMN $colname ";

Having trouble with xoopsDb->query
DELETE request problem.

MySQLDatabaseSafe and MySQLDatabaseProxy

Amazing what a search can yield