multiple row values in single variable

[chandru123]

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 :

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)) {
$csk = "'".$row['NAME']."',";
}
echo $csk;

[Rabbit]

Please use code tags when posting code or formatted data.

The problem is that you haven't appended the value to csk. You keep replacing it with a new value.