what am i doing wrong

I'm quite frustrated. I must be doing something wrong because I can execute queries in functions just not regular page... I've tried everything that seemed obvious....

I tried both db_Select() and db_Select_gen()...
Like I said I used db_Select() in functions without problems.... I even tried starting a new connection and still nothing.

$sql->db_Select('league_officials', '*') - there isn't anything wrong with this is there?

I'm going to guess that's the exact line you're using. You need to tell the function that there is no other parameters, like this:

Thanks for your reply. In my function I only have $sql->db_Select('league_games', 'game_name, game_title') and it works. i made function to generate <select> option list. I know how to code. I've completed my league management script but I am disatisfied with the cms. now I'm porting it over but making it better. like I said I am clueless. I will try what you said...

Edit:
It is working but that's not why. I restarted the server so maybe that's why... thanks for your input. you did help.

My advice was rubbish. I was thinking of something else.

I'm assuming you got it working?

yes! thanks for trying help. I edited my last post the other day. something weird was going on. I've been trying to transition and its hard trying to figure it all out. I've looked through a bunch of the handlers and have tried to figure out all the bells and whistles. I knew it should've been working but wasn't sure why... take care.

Again, thanks for your input. sorry for waste of time.