Query Mysql. Post to a web page

select phone_number,from device_status where bal <>'0.00' and phone_number>'1' and updated_at > date_sub(now(),interval 5 minute) and bal < '5000' and tries < warn and accumulated < x; Some entries will be found Log into a web form *225*[number]*[rand]# where rand will be a random number in a range rounded to a certain amount. Click send. increment tries=tries+1 accumulated=accumulated+rand Example perl script which performs a similar command on the same page. if con: [login to view URL]() def send_message(self): '''Sends loaded data to server. self.unknow_number and self.known_number must be defined''' br = [login to view URL]() cj = [login to view URL]() # Browser options br.set_handle_equiv(True) #br.set_handle_gzip(True) br.set_handle_redirect(True) br.set_handle_referer(True) br.set_handle_robots(False) # Follows refresh 0 but not hangs on refresh > 0 br.set_handle_refresh([login to view URL](), max_time=1) # User-Agent (this is cheating, ok?) [login to view URL] = [('User-agent', 'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.1) Gecko/2008071615 Fedora/[login to view URL] Firefox/3.0.1')] r = [login to view URL]('[login to view URL]') br.select_form(name='login') [login to view URL]['username'] = 'root' [login to view URL]['password'] = 'vijay' [login to view URL]() #print [login to view URL]().read() [login to view URL]('[login to view URL]') #print [login to view URL]().read() br.select_form(name='myform') [login to view URL]["smsnum"] = self.known_number[0] #[login to view URL]["smsnum"] = "16312686765" #set for debug [login to view URL]["Memo"] = "Is this it? %s" % self.unknown_number[1] #[login to view URL]["smsgoip"] = self.unknown_number[0] #wrong approach #[login to view URL]['smsgoip'] = ["181"] #set for debug item =br.find_control(name="smsgoip", type ="select").get(label=self.unknown_number[0]) item.selected=True #does this work? [login to view URL]() import re search = [login to view URL]('([login to view URL]\?messageid=\d+&USERNAME=&PASSWORD=)') [login to view URL]('[login to view URL]'+[login to view URL]([login to view URL]().read()).group(1)) #print [login to view URL]().read() def process_task(self): ''' Does all tasks. Loads data from db and sends it to remote server.''' self.get_data_from_db() self.send_message() def __init__(self): self.process_task() if __name__=='__main__': UnknownNumbersSender() This page does not have anythign like a capcha . Only a username and password If the script is already running, ensure It does not run again.