I hav a query that I use for getting a specific record. There are five keys that make up the pk of the table.
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.
$query = "Select * FROM schedule
WHERE CourseNum = '" . $this->CourseNum . "' AND
SectionNum = " . $this->SectionNum . " AND
PidNum = '" . $this->PidNum . "' AND
BDate = '" . $this->BDate . "' AND
Preceptor = " . $this->Preceptor;
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.