View Single Post
Old 10-24-2006, 06:37 AM   #2 (permalink)
teknomage1
Jack of all trades
 
teknomage1's Avatar
 
Join Date: Feb 2005
Location: Los Angeles
Posts: 598
teknomage1 is on a distinguished road
Send a message via AIM to teknomage1
I think you could calculate it all with a single query like this:
Code:
$query = "SELECT (MIN(price)+MAX(price))/2 as median FROM condo03 WHERE (full_add like '%$Text_Box_1%' OR full_add like '%$Text_Box_2%' OR full_add like '%$Text_Box_3%' OR full_add like '%$Text_Box_4%') AND (status = '$status') AND (size >= '$Text_Box_15' AND size <= '$Text_Box_16') GROUP BY 'date' ASC");
__________________
Stop intellectual property from infringing on me

Last edited by teknomage1; 10-24-2006 at 06:38 AM. Reason: left out [/code] tag
teknomage1 is offline   Reply With Quote