J
Jamie Fryatt
Hi Guys, i have an access database with 5 records in and i need to show them
in a random order every time the page is refreshed or reloaded.
i've searched round and tryed no end of code but nothing seems to work.
i just need something really simple that selects a random feild from my DB.
Sql = "SELECT * FROM tblmain ORDER BY RND()" - ive tryed this and it just
shows the results in teh same order.
this is desperate help is need and will be gratefully recieved.
thanks
Jamie
in a random order every time the page is refreshed or reloaded.
i've searched round and tryed no end of code but nothing seems to work.
i just need something really simple that selects a random feild from my DB.
Sql = "SELECT * FROM tblmain ORDER BY RND()" - ive tryed this and it just
shows the results in teh same order.
this is desperate help is need and will be gratefully recieved.
thanks
Jamie