1
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