5
Ok, its nice to know where the db class documentation is. That said, I've looked through it and what you're suggesting looks right to me, however, I'm still getting the same error.
This leaves me in the position that I can add records to the database using:
$result = $xoopsDB -> query("INSERT INTO `xoops_caseyguestlist` (name, street1, street2, city, state, zip) VALUES ('$name', '$street1', '$street2', '$city', '$state', '$zip')");
but can't get them out with any of the suggested code.