I have a sql query that has a Where caluse based on an integer value. The problem I have is that I want to be able to pass a default value to get all of them ( like using a % symbol to get any string ), but I can't figure out what I need, I have tried * and such.
Here is the query:
The Year value is what I am trying to get to work out.PHP Code:
$query = "Select * FROM student INNER JOIN person on person.ID = student.PersonID WHERE Year = $Year ORDER BY lname, fname";
Thanks for the help