re-using query help

[deuce868]

I hav a query that I use for getting a specific record. There are five keys that make up the pk of the table.

$query = "Select * FROM schedule 
WHERE CourseNum = '" . $this->CourseNum . "' AND 
SectionNum = " . $this->SectionNum . " AND 
PidNum = '" . $this->PidNum . "' AND 
BDate = '" . $this->BDate . "' AND 
Preceptor = " . $this->Preceptor; 

Now the BDate is a date field and I am trying to get this to allow me to pass in some wildcard values to get a series of records rather than just one.

I can change the text based fields (like course number) from = to LIKE and use %, but how can I get this to work with the date. If I change the BDate to LIKE it breaks.

Thanks

[peanuts]

Hmmm you could just use the date functions that mysql offers to do all kind of nice tricks ...

The most common are
where date > $begin and date < $end
of
where date between $begin and $end

these ofcourse only work if mysql knows that the field is date...

also check
http://www.mysql.com/documentation/m...e_calculations

good luck....

Peanuts

[deuce868]

I think I goofed something else. I played with it some more and I have gotten it to work out.

Thanks