Randomly selected object always returns the same

[johnie]

Hi. I have a strange situation here.
I have a code that retrieves something randomly from a db (MySQL). The code doesn't matter because it's standard and there's no need to quote it here.
The strange thing is that when it outputs, it gets me always the same row, the first one.
When i run the query in a GUI it works ok(it retrieves random rows).

This situation only happens on a web host. On my local machine it works perfect.
Has anyone faced a similar situation. Is there a trick i should know? I'm stacked and i've tried everything.

Thanks

John

[planetsim]

You are using rand()

[johnie]

I'm using ORDER BY RAND() if that's what you mean, not php's rand(). I'm using it in other scripts and applications and it works fine.

John