equiv of % for int field?

[deuce868]

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:

 $query = "Select * FROM student INNER JOIN person on person.ID = student.PersonID WHERE Year = $Year ORDER BY lname, fname"; 

The Year value is what I am trying to get to work out.

Thanks for the help

[Chris82]

Hi.

If you drop the where clause, all rows will be returned

$query = "Select * FROM student INNER JOIN person on person.ID = student.PersonID ORDER BY lname, fname"; 

[deuce868]

lol

Yea, I was just trying to reuse a function rather than create two.

Thanks though.

[MarcusJT]

Assuming that the year is normally passed as 4 digits, why don't you use zero as your special value?

[deuce868]

the year is not that kind of year. We have students that are either 1st year, 2nd year, 3rd, 4th. Because it is not tied with a date I just have a field that tracks which they are with a single digit.

[r937]

the best way to deal with this situation is to code your app to handle both situations -- either a value is passed in or it isn't -- and construct the sql accordingly

failing that, you could consider doing some sql injection of your own

try running the query with $Year set to 9 or 1=1

rudy

[deuce868]

I am thinking about changing the database field to a single char and then limiting the values to 1-4 in the validation code I use. I really have no need to deal with it as a number expect for the fact that it is just a number. I can treat like a char I think and everything I already have will work. I just need to add a bunch of quotes to all the funtion calls.

Thanks for the help on this. Sometimes you just don't see it all right the first time you lay it out. :-)

[shane]

Just do it as M@rco suggested. That way you can leave the Year field as numeric field.

$query = "SELECT *
FROM student
INNER JOIN person on person.ID = student.PersonID
WHERE ($Year = 0 OR Year = $Year)
ORDER BY lname, fname";

[deuce868]

Thanks for the tips. I did try it out with shane's suggestion for modifying the query and it works.