Mega Array Problem

[accurax]

I shall do my best to explain here, if im not being clear enough about this please tell me,

I have a database containing information about all of my users, and i would like to add the ability for users to search for each other.

So, i have created a simple form that should allow users to search by sex, location and specify a minimum and maximum age.

The location and sex works fine, its a simple sql query after all.

But im having hair pullingly annoying problems with making the age range search function correctly.

At this moment in time the code that follws simply appears to do nothing... no out put or error messages of any kind whatsoever, which has really got me going bald fast as im sure you can imagine.

Some help is needed i feel.

My database is structured as follows (and yes i know the way i handle dob' is odd) :p

user_name - primary
sex
location
day - (the day of the month they were born on - numerical [dd])
month - (the month they were born in - numerical [mm])
year - (the year they were born in [yyyy])

for now i just want to acheive a situation where i can print out the names of each user who meets the search criteria.

here is my code so far;

<?php
error_reporting(255);

session_start();
include("../secrets.inc");
if ( $_SESSION['logged'] != "true" )
	{
		header("location: ../login.php");
	}
else
	{
		$connection=mysql_connect($hostname, $username, $password)
		or die ("Could not connect !");
		$db = mysql_select_db($db, $cnnctn)
		or die ("Could not connect to Database");

$sex = $_POST['search_sex'];
$loc = $_POST['search_location'];
$min_age = $_POST['search_age2'];
$max_age = $_POST['search_age1'];

$user_query = "SELECT * FROM members WHERE sex='$sex' AND location='$loc' ORDER BY last_updated DESC";
$result = mysql_query($user_query)
	or die ("no can do");

$today = date('d-m-Y');

$a_today = explode('-', $today);

$day_today = $a_today[0];
$month_today = $a_today[1];
$year_today = $a_today[2];


while ( $row = mysql_fetch_array($result))
{
//calculates the age
$day = $row['day'];
$month = $row['month'];
$year = $row['year'];

$birthday = $day."-".$month."-".$year;

$a_birthday = explode('-', $birthday);

$day_birthday = $a_birthday[0];
$month_birthday = $a_birthday[1];
$year_birthday = $a_birthday[2];

$age = $year_today - $year_birthday;

if (($month_today < $month_birthday) || ($month_today == $month_birthday && $day_today < $day_birthday))
{
$age--;
}

   if (($age >=$min_age) && ($age <= $max_age)) {
      $members [] = $row;


   foreach ($members as $key => $value) 

   print $value['user_name'];


}
}
	}

?>

I'm really starting to loose it with this code...... is there anyone out there who can help?

Accura

[leatherback]

First off.. store date the way it is meant to.. In a date field. After that the troubles shall be over very quickly.

[accurax]

you really think thats the crux of the issue here?

[leatherback]

Yest. After that you can select from table where date between DATE1 and DATE2

edit|: Although I do admit I have not looked at your code with any scrutiny. Storing date as numbers or text in a database and than stating you have trouble making a query work is for me enough info to say... Make sure you store the dat ecorrectly. After that we can look further into your code.

[accurax]

ok ....... i didnt even realise i should do it that way if im honest.

ive created a field in my database, and ive inserted some data.... it goes in as yyy.mm.dd

i dont suppose i could bother you for some advice on modyfing the above code to accept this new date format could i please?

[leatherback]

What is the field type? Date, I presume?
I insert date like this:

$startdate        = $pnewsitem['syear']."-".$pnewsitem['smonth']."-".$pnewsitem['sday'];


$nextprocess = "update";
$DBH = db_connect();
$result = mysql_query("insert into ".$newsitems_table."
         (N_title, N_content, N_date, N_edate, N_link, N_contact, N_contact_link, N_calender, N_type, N_sponsored, N_show, N_location) 
 values ('$title', '$content', '$startdate', '$enddate', '$link', '$contact', '$contact_link', $calender, $type, $sponsored, $show, '$location')")or handlerr(mysql_error(),21);
db_disconnect($DBH);

[accurax]

ok, ive modified the code to use a field in my database cakked 'age' this is stored in DATE and is of the form yyyy-mm-dd

im then exploding this to let me do the comparisons, problem is im still geting zero output, and no error message's either.

Any chance of you casting your eye over it for me?

here it is as stands;

<?php
error_reporting(255);

session_start();
include("../secrets.inc");
if ( $_SESSION['logged'] != "true" )
	{
		header("location: ../hacker.php");
	}
else
	{
		$connection=mysql_connect($h, $u, $p)
		or die ("Could not connect !");
		$db = mysql_select_db($db, $con)
		or die ("Could not connect to Database");

$sex = $_POST['search_sex'];
$loc = $_POST['search_location'];
$min_age = $_POST['search_age2'];
$max_age = $_POST['search_age1'];

$user_query = "SELECT * FROM members WHERE sex='$sex' AND location='$loc' ORDER BY last_updated DESC";
$result = mysql_query($user_query)
	or die ("no can do");

$today = date('d-m-Y');

$a_today = explode('-', $today);

$day_today = $a_today[0];
$month_today = $a_today[1];
$year_today = $a_today[2];


while ( $row = mysql_fetch_array($result))
{
//calculates the age
$dob = $row['age'];

$a_birthday = explode('-', $dob);

$year_birthday = $a_birthday[0];
$month_birthday = $a_birthday[1];
$day_birthday = $a_birthday[2];



$age = $year_today - $year_birthday;

if (($month_today < $month_birthday) || ($month_today == $month_birthday && $day_today < $day_birthday))
{
$age--;
}

   if (($age >=$min_age) && ($age <= $max_age)) {
      $members [] = $row;


   foreach ($members as $key => $value) 

   print $value['user_name'];


}
}
	}

?>

[leatherback]

You'd be better of having mysql do the comparison.

If you have a max age and a min age, you know the date limits, namely: today - max age and today - min date. You can the use mysql to
"select from table where date>$maxage && date<$minage"

[Installer]

Something like this:

$min_date = date('Y-m-d', strtotime('-' . $min_age . 'years');
$max_date = date('Y-m-d', strtotime('-' . $max_age . 'years');

$user_query = "SELECT * FROM members 
               WHERE sex='$sex' AND location='$loc' AND dob BETWEEN '$min_date' AND '$max_date' 
               ORDER BY last_updated DESC";

[accurax]

dont i need to convert the inputted age variables into dates to compare them to the stored date of birth?

[Weedpacket]

That's what the date(...strtotime()) lines are doing.