Hi: I have a statement such as follows SELECT EVENT_DATA.dstport WHERE FROM_UNIXTIME(utime,'%Y-%m-%d') = (CURDATE() - INTERVAL 1 DAY) ORDER BY EVENT_DATA.utime;
Instead of using a value of 1 for interval, I want to pass parameters so it will ask for the value when the sql statement is run. I have tried searching in google and www.mysql.org and have not had any luck. Does mysql use different definitions? or can someone provide some pointers on the web which explains how to pass parameters with SQL statement. Thanks Ravi __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
