loop throw days problem

wipeskim

Hey All,

I am trying to show the hotel room prices per each day for that i query the database between a date let's say between '2010-09-01' and '2010-10-30'.

Currently on my database the records only show up till '2010-10-07' but i would like that even if doesn't has records in database to follow the rest of the days till '2010-10-30' that will be shown as not/available.

I tried this by using a loop throw the date variables and then per each day i would query the database for records, the problem is that i have 16000 records and it takes quite a while to show the results.

this the code i am using now:

$start_date = '2010-09-01'; 
	$check_date = $start_date; 
	$end_date = '2010-10-30'; 
	$i = 0; 

while ($check_date <= $end_date) { 

	$sel_rate = mysql_query("select day_add,price from contract_rates 
	where day_add='".$check_date."' ");
	$get_rate = mysql_fetch_array($sel_rate);

	echo "date: ".$check_date." Price:".$get_rate['price']."<br>";

	$check_date = date ("Y-m-d", strtotime ("+1 day", strtotime($check_date))); 
	$i++;

}

If someone know's a better solution i would appreciate it

thanks

dagon

ouch one query per day! for a start use BETWEEN in your query

$sel_rate = mysql_query("select day_add,price from contract_rates 
		where day_add BETWEEN $start_date AND $end_date");

wipeskim

hi Dagon, thanks for reply i tryed that before but the thing is that the date has to match the first loop.

if i just use what you did and do one loop with it, it will only list till the 2010-10-07 as i have it only on my database, the thing is to return on each day the price but without doing what i did on my posted code as it will make several queries and take a while to return results.

if you have other ideas let me know

dagon

i would still do the above and either fill in the holes in the while loop or store the db results in an array and loop through the date range pulling the data from the array when the date matches. Either option will be a lot faster than multiple queries.