Storing all rows retrieved in a query in an array for validation

[samannoychatter]

I want to store the data from my sqltable after fetching them in an array so that whenever i want i can validate it. What is the way out.

I am using these codes but i can't work out.

I need all the rows for the field of a table to be stored..

$query  = "SELECT booked_dates FROM booking_dates";
$result = mysql_query($query);

$booked_date = array();
while(list($bookeddates)=mysql_fetch_row($result))
{
$booked_date[].= $bookeddates;
}

$a=2010-11-01;

foreach($booked_date as $value == $a)
{
 echo $value."Booked";
}

Please reply.

[dagon]

would be a lot easier to just add a WHERE to the mysql "WHERE booked_dates = '$date'
than to retrieve them all then search with php

[samannoychatter]

My Purpose is to use these data in calender. If the date of calender matches the booked date that date style would be different. for that i need a solution.

My Code is as follows ::

<?php
////// End of the top line showing name of the days of the week//////////

   $bookin_date=array();
   $date_query="select booked_dates from booking_dates where apartment_id='22' ORDER BY booked_dates ASC ";
   $date_query=mysql_query($date_query);
   while(list($booked_date)=mysql_fetch_array($date_query))
  {
	$bookin_date[]=$booked_date;  
  } 
  foreach($bookin_date as $value1)
  {
   echo $value1."<br>";	  
  }
//////// Starting of the days////////// 
	 for($i=1;$i<=$no_of_days;$i++)
	 {


//echo "BOOKED DATES - ".$bookin_date."<br>";	  	 
	   foreach($bookin_date as $values)
	   {
		$cal_date=$yn."-".$mon."-".$i;   

	      if($values==$cal_date)
           {
	        $classvalue="cl1";
           }
	   }
	   echo $adj."<td align='center' valign='middle'";
       echo "class='".$classvalue."'>"; 
       echo $i; // This will display the date inside the calendar cell
       echo " </td>";
       $adj='';
       $j ++;
       if($j==7){echo "</tr><tr class='dt'>";
       $j=0;}
     }
?>