View unanswered posts | View active topics It is currently Wed Nov 29, 2023 7:35 pm

Reply to topic  [ 2 posts ] 
 Have table with lotto numbers, need HELP pls... 
Author Message
Junior Member

Joined: Sun Sep 13, 2009 2:28 pm
Posts: 1
Post Have table with lotto numbers, need HELP pls...
Hi new to the forums. Been looking to find a solution for about a week now and thought I would try here to find the answer.
Have a table with fields Ball1,Ball2,Ball3,Ball4,Ball5,Ball6,BonusBall
They are all populated with random numbers between 1 to 49 and have 25 records in the table.
I am trying to create a select query that will order the winning results from some external values which a person picks... They will make there own pick of Ball1 to Ball6 and BonusBall selecting numbers between 1 to 49.
So these values are pass to the query string.
I want to order by the first results haven 7 wining numbers and then 6 down to 1 and then continue with results that did not have any numbers
Just like a lotto hehehe.... Winner at the top with 7 number and all below with combination below 7 like 6,5,4,3,2,1 and no numbers matching...
Hope you understand...

Sun Sep 13, 2009 3:26 pm
Report this post
Display posts from previous:  Sort by  
Reply to topic   [ 2 posts ] 

Who is online

Users browsing this forum: No registered users and 0 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
© Copyright 2003-2008 The ultimate PHP Editor and PHP IDE site.