[standXalone]

i have a form set up, and have the option for users to search the user's table for the last time a member has updated their profile. i have the search options as:

<FORM NAME="search" ACTION="members.php" METHOD="GET">
<select NAME="last_update" class="select" style="width:121px;">
<option VALUE="today">Updated Today</option>
<option VALUE="yesterday">Updated Yesterday</option>
<option VALUE="last_week">Last 7 Days</option>
</select>&nbsp;<INPUT type="submit" value="Go" style="font-size: 7pt; font-family: Verdana; background-color: #E9E9E9"><input type="hidden" name="last_update" value="1"></form>

now, the sql for this is as follows...

if (isset($_GET['last_update'])) {

if ( $HTTP_GET_VARS['last_update'] == "today" )
{
$length = 1;
}
else if ( $HTTP_GET_VARS['last_update'] == "yesterday")
{
$length = 2;
}
else if ( $HTTP_GET_VARS['last_update'] == "last_week")
{
$length = 7;
}

$time_period = time() - ($length * 86400);
$links_sql .= ' WHERE user_update >= '. $time_period.' ';
$total_records_sql .= ' WHERE user_update >= '. $time_period.' ';
};

on submit, it is not returning any values. i commented our the $time_period variable and recieved this
today - 1079556944
yesterday - 1079556959
a week - 1079556973

can anyone help? i really need to get this finished

[Infinite_Hackers]

Hey,
Coudl you tell me first in what way is the time stored in the database (seconds, minutes or w/e)

[standXalone]

it is being stored as time() everytime the update profile page is submitted

[Infinite_Hackers]

*slaps him self*
*sec ill get back to you-- i made a mistake and i can't seem to delete posts on this from [gets mad]*

Simple..

Code:

<INPUT type="submit" value="Go" style="font-size: 7pt; font-family: Verdana; background-color: #E9E9E9"><input type="hidden" name="last_update1" value="1">

is the same name as the drop down menu. change it to something else ;D

[standXalone]

hey again... i got it almost working, however, when i do a search for today, or yesterday, i get results from a couple different days, not just from what im looking for... here is the code i have so far

if (isset($_GET['last_update']))
{
if ( $HTTP_GET_VARS['last_update'] == "today")
$length = 1;
else if ( $HTTP_GET_VARS['last_update'] == "yesterday" )
$length = 2;
else if ( $HTTP_GET_VARS['last_update'] == "last_week" )
$length = 7;

$time_period = time() - ($length * 86400);
$links_sql .= ' WHERE user_update >= '. $time_period.' ';
$total_records_sql .= ' WHERE user_update >= '. $time_period.' ';
}

[standXalone]

can anyone help? it would be much appreciated