Shawn - You answered the right question. Since a SQL statement is closer to my grasp right now , today, trying that approach.
I think this is something close to correct, though I'm stuck on what to assign to @usrDays:= SELECT DateEntry from Entry_Table, WHERE DateEntry >= DATE_SUB(CurDate(), Interval @usrDays:= <?> day ) I'll continue to bang away , eventually I should get it. Stuart --- [EMAIL PROTECTED] wrote: > Stuart, > > I feel you pains. I think I can speak for most of us > to say "we've been > there, too" > > First, You want to try to keep your column values > on the LEFT side of any > inequality. MySQL just goes faster that way. > > SELECT .... > WHERE EntryDate >= DATESUB(CurDate(), > Interval 2 day ) > > About using a variable for your date value, you have > two options. First, > you could just modify your PHP code to stick a > number into the correct > place of your SQL statement: > > $querystring = "SELECT .... WHERE EntryDate >= > DATESUB(CurDate(), Interval > ". $daysdiff ." day )" > > Or you can create SQL statement that sets a MySQL > variable that contains > the # of days you want to subtract then use that > variable in your WHERE > clause. Either way you are combining the value you > get from the user-entry > field and using it to create a valid SQL statement. > Personally, I would > do the first. (my logic: I don't need the variable > except to use it in the > very next statement and if I have to merge values > and text once, anyway, > why not just put the correct value into my original > query) > > Please let me know if I answered the wrong question, > OK? > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > > > Stuart Felenstein <[EMAIL PROTECTED]> wrote on > 09/13/2004 11:54:02 AM: > > > Shawn, partially discourage but mostly confused > about > > what I really need to do. > > > > Bear in mind for a moment, that I'm working in a > > somewhat untradional manner. Meaning a) very new > to > > database and SQL b) (and i realize this list is > not > > for programming languages) using a RAD that allows > me > > to point, click and insert , where it's magically > > transformed into code. > > > > So back to what I'm trying to accomplish. I want > a > > way for the user to be allowed to choose from what > > point in the timeline records will be returned in > a > > search. i.e. from 30 days or less, 15 days or > less, 2 > > days or less, etc. > > > > Now, if I run this query against the > > entry_table.entry_date_column > > > > select EntryDate from EntryTable > > where Date_Sub(Curdate(), interval 2 day) <= > EntryDate > > > > life is good. I get the records returned just the > way > > I want. They key though is the 2 (after interval) > as > > I want that number to be a variable. > > > > That is why I created the table that has values of > 1, > > 2 , 15, 30, etc). I thought if I could use those > > values, in either a case statement (probably not > with > > 4.0.20) or an "if statement" , well magic would > happen > > ;) > > > > I hope I explained it better this time. > > Apologies for the confusion. > > Stuart > > --- [EMAIL PROTECTED] wrote: > > > > > Were you able to solve you problem another way > or > > > just discouraged by my > > > response? I wasn't trying to make you feel bad, > you > > > just covered so much > > > ground in your original post that I really > couldn't > > > understand your issue. > > > Please, post again but with a little more > > > background. > > > > > > We all want to help but we aren't there looking > over > > > your shoulder so we > > > can't see everything you see. We just need a > little > > > help to visualize your > > > problem, OK? > > > > > > Respectfully, > > > > > > Shawn Green > > > Database Administrator > > > Unimin Corporation - Spruce Pine > > > > > > Stuart Felenstein <[EMAIL PROTECTED]> wrote on > > > 09/13/2004 11:09:59 AM: > > > > > > > Ok, never mind . I guess a conditional loop > is > > > not > > > > needed. > > > > > > > > > > > > Stuart > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
