View Single Post
Join Date: Aug 2008
Posts: 1,160
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 137
dickersonka dickersonka is offline Offline
Veteran Poster

Re: Transfer of data

 
0
  #7
Nov 21st, 2008
event i believe is only only available in 5.1.6

select into with my sql is an insert statement with a select

  1. INSERT INTO Out(recipient, Text)
  2. SELECT recipient, Text FROM Schedule WHERE TimeToSend = curdate();

i would suggest timetosend be <= curdate(), you'll never get a match exactly on times most likely unless you are going by date only
Custom Application & Software Development
www.houseshark.net
Reply With Quote