Can't Get My Head around this..

[mrchuckles2002]

Anyone who can free my mind from struggling to work this out will be adored forever.

I have two variables $first_shown & $last_shown. Each being years, so in example A: first shown maybe 1973, last shown will be 1981, for example.

I want to allow users to do a search displaying for all records shown in their given year. How could i make it so, if they type 1977, example A will show up.

I was thinking this would be straight forward when i planned it!! I'm thinking you would need to develop some variable through subtraction..

something like..

$years = $last_shown - $first_shown

that would give you $years a figure like 8, for example a. then you would need to add one to $first_shown for every interger in $years , thus providing 1973,1974,1975 and so on..

How could i do this, I'm guessing I'll have to develop some sort of loop?

any help will be appreciated, thanks in advance.

[toplay]

I'm not sure if I understand you exactly. The example below assumes you want to retrieve all years within an 8 year window from the user's input. Also, I assume you have a column of type DATE or DATETIME. If you have a column that just contains the year value, then remove the YEAR() function from the SQL.

$year_range = 8;

$year_inputed = 1977;  // An example of what a user entered

$first_shown = $year_inputed - ($year_range / 2);  // 1973

$last_shown = $year_inputed + ($year_range / 2); // 1981

$sql = "SELECT * FROM table_name 
WHERE YEAR(date_column) BETWEEN $first_shown AND $last_shown";

// Do query and fetch here

FYI - You could also use >= and <= in the "where" clause.

🙂

[mrchuckles2002]

Thanks, I was unaware of the between function.