PHP - Retrieve multiple records from a single mysql table and append to a string

Question

I have the following table in mysql. I need to select the Hid(s) from this table and append the results to a string '$s'. It would be great if you could help.

Table name : CASES

Did   Hid   Year  Case
---   ---   ----  ----
 1     1    2011   6
 1     1    2012   7
 2     2    2011   40
 2     2    2012   10

php code segment:

$did=1;
$yr=2011;
$s='';
$q="select Hid from CASES where Did=$did and Year=$yr and Case!=0 ";
$r=mysql_query($q);
while($rw=mysql_fetch_assoc($r))
{
    //I need to append the Hid(s) to a String '$s' declared above
}

$s.= $rw["Hid"]; which is shorthand for $s = $s.$rw["Hid"]; — Orangepill
– Orangepill, Commented Jul 24, 2013 at 5:57

0x6A75616E · Accepted Answer · 2013-07-24 05:58:10Z

1

Assuming your query works, which it looks like it might:

$did=1;
$yr=2011;
$s='';
$q="select Hid from CASES where Did=$did and Year=$yr and Case!=0 ";
$r=mysql_query($q);
while($rw=mysql_fetch_assoc($r))
{
    $s .= $rw['Hid'];
}

That will just give you a string with all of the Hids together.. if you want to have a character in between or something else, you could:

$did=1;
$yr=2011;
$s=array();
$q="select Hid from CASES where Did=$did and Year=$yr and Case!=0 ";
$r=mysql_query($q);
while($rw=mysql_fetch_assoc($r))
{
    $s[] = $rw['Hid'];
}
$result = implode( ',', $s );

$result above will end up with a comma-separated list of Hids.

answered Jul 24, 2013 at 5:58

0x6A75616E

4,7142 gold badges35 silver badges58 bronze badges

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

1 Comment

JeNy Over a year ago

Thank you everyone for posting answers and suggestions for my thread.

federicot · Accepted Answer · 2013-07-24 05:59:06Z

0

Use the string concatenation operator:

$s .= $rw['Hid'];

answered Jul 24, 2013 at 5:59

federicot

12.3k19 gold badges71 silver badges111 bronze badges

Comments

Umar Farook · Accepted Answer · 2013-07-24 05:59:58Z

0

Get/ retrieve the data's to an array and implode it to a string. Refer http://php.net/manual/en/function.implode.php

for implode

answered Jul 24, 2013 at 5:59

Umar Farook

11 bronze badge

Comments

Zia · Accepted Answer · 2013-07-24 06:02:38Z

0

$did=1;
$yr=2011;
$s='';
$q="select Hid from CASES where Did=$did and Year=$yr and Case!=0 ";

    $r=mysql_query($q);
    while($rw=mysql_fetch_assoc($r))
    {
        $s .= $rw['hid'] . '<br />';
    }



echo $s;

answered Jul 24, 2013 at 6:02

Zia

19112 bronze badges

Collectives™ on Stack Overflow

PHP - Retrieve multiple records from a single mysql table and append to a string

php code segment:

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

php code segment:

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related