Hi, I was wondering if anyone ever had this problem with sql... Using a random query to get a random result, it gives me a random result I want until the 4th or 5th time I ask it and then it just duplicates teh last one endlessly ... Does anyone know why this might be? Thanks
Your random number generator seed has degenerated into the same number every time. You need to set your random number generator parameters.
Can you post the code and how you're running the script. There are a number of built-in caching mechanisms in everything from a web browser to a database server. My guess is that assuming the script isn't broken, there something caching a result.