I have a form element which allows a user to go back "x number of days" in the records. $sql.=sprintf("SELECT * FROM records WHERE Date_Sub(Curdate(), interval day) "$%s" <= PostStart") This formula works when I actually hardcode the number of days in where this mess --> "$%s" is right now. I'm not entirely sure how this should be coded. Can I put the variable right there? I'll take any suggestions, cause I'm stuck here. Thank you, Stuart -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php