10
Yeah, I know XOOPS adds it, but how do I, in the code itself, get the default prefix?
For example, if the users default prefix is cms_ instead of xoops_, then how do you, when you need to withdraw something from the database, know what to query?
here is an example query from my code:
$query = "SELECT * FROM xoops_books_items WHERE valid='1' ORDER BY RAND() LIMIT 1";
It wont work if the default prefix isnt xoops...how do I change it so it gets the default prefix?