i am adding all names in to single variable but it is showing only one value last one. any one knows solution for this.

my code is :

Code:
include 'dbconnect.php';
$result = mysql_query("SELECT * FROM bookedtates WHERE SID='$ServiceHosterIdv' AND BOOKEDDATE='$q'");
//$result = mysql_query("SELECT * FROM bookedtates WHERE SID='$ServiceHosterIdv' AND BOOKEDDATE='$q'");

while ($row = mysql_fetch_assoc($query))
...