Ok I redid the SQL statement again, and this time it works. *pulls hair out*

$sql = "SELECT `charid`,`character` FROM `xoops_ffxi_manager` WHERE `charid` = 1";

Is the statement I used. picky picky.

Thanks Mith for trying to help me out with this, it is much appreciated!

Is there a configuration for mySql in linux to make it not need the ` in statements?

looks like it's not recognising the dbquery function.. maybe u haven't included a file somewhere in the include/require statements so that XOOPS objects are recognised.. (again i'm no php coder) just a learner..

The backquotes `` around table names or column names are only needed if those names contain spaces (or possibly other special characters), which is not the case here.

Also, WHERE 'charid' = 1 is not what you want. That's comparing the character string 'charid' with the value 1, not comparing the value of the column charid with the value 1. The character string 'charid' is obviously never equal to 1, so WHERE 'charid' = 1 is equivalent to WHERE 0, which is valid, but produces no output.