Multiple database row values in single variable

Question

I am adding all names in to single variable but it is showing only one value last one.

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;

What is your question?

Oswald
– Oswald

2013-10-04 07:21:36 +00:00
Commented Oct 4, 2013 at 7:21 — Oswald
– Oswald, Commented Oct 4, 2013 at 7:21

SergkeiM · Accepted Answer · 2013-10-04 07:22:13Z

1

No u just assign variable use it to plus add a "." before equtaion

  $csk .= "'".$row['NAME']."',";

But I would suggest to use array so u can use for JS(if ajax) or php for more flexible things

$csk = array();
while ($row = mysql_fetch_assoc($query)) {
$csk[] = array($row['NAME']);
}
echo $csk; //for ajax use echo json_encode($csk);

answered Oct 4, 2013 at 7:22

SergkeiM

4,1886 gold badges40 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Chandrashekar Chandru Over a year ago

i have used this but it is displaying only "array"

SergkeiM Over a year ago

try print_r($csk); You shold get it but to output the array you need loop

zerokavn · Accepted Answer · 2013-10-04 07:25:29Z

0

just test with

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

answered Oct 4, 2013 at 7:25

zerokavn

1,3331 gold badge9 silver badges10 bronze badges

Comments

Scott Helme · Accepted Answer · 2013-10-04 07:25:40Z

0

You are resetting the variable to the value of $row['NAME'] on each iteration of the loop.

What you need to do is append the variable to the end of $csk:

$csk .= "'".$row['NAME']."',";
     ^---- notice the extra . here

The extra . indicates that you want to append the value to $csk.

answered Oct 4, 2013 at 7:25

Scott Helme

4,7942 gold badges27 silver badges35 bronze badges

Collectives™ on Stack Overflow

Multiple database row values in single variable

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related