Re: How to pass parameters in MYSQL

2006-04-10 Thread Peter Brawley
Ravi Malghan wrote: 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 st

Re: How to pass parameters in MYSQL

2006-04-10 Thread Shawn Green
--- Ravi Malghan <[EMAIL PROTECTED]> wrote: > 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