intodesi

Very Cool thank you very much for the example, I can see how what I want to do needs to be done, i didnt know about the "ORDER BY RAND()" string. Thanks again, I will post back as soon as I am able to get it tested.

Hello, What I am trying to do is get semi random data from a MySql table. I have a database named kidpatrol, which has 4 tables under it, kids, parents, cards, and tracking. The first thing in my project that I would like to complete, would be figuring out how to grab a semi random row from the cards table, based on user selection and past events. in the cards table, there are 4 rows, card_id, card_diff, card_name, card_text. card_diff is for card difficulty, what i need to be able to do is when I display a choice of three difficulties (which i can do) and when that specific difficulty is chosen a random card is displayed, if that card has not been displayed before. so my script has to be able to 1) Get a random card based on difficulty. 2) Make sure that the Card has not been used before a) Using the tracking table to accomplish this. Tracking table has three rows. kid_id, card_id, and date. Any help would be great, basically I gave a whole bunch of info, but all i need to do is figured out how to grab the data from the cards table randomly after the kid selects difficulty, and then make sure that the specific card has not been used. Thanks

I would like to add http://www.hostony.com can I post my affiliate link ?