PHP help -- displaying multiple rows

Question

I am fetching some data from a database like this

$sql ="SELECT * FROM table WHERE field1 LIKE '%$name%'";

And the result of this is many rows, how can i display all the rows using PHP?

If its just for one row i am using this:

$sql ="SELECT * FROM table WHERE field1 LIKE '%$name%'";       
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
$abc_output= "Data Fetched <br />";      
$abc_output .="name: " . $row['name'] . "<br />" ;
$abc_output .="age: " . $row['age'] . "<br />" ; 
$abc_output .="sex: " .  $row['sex'] . "<br />" ; 
$abc_output .='<a href="abc.com"> Back to Main Menu</a>';
 }
echo $abc_output;

How can i display for multiple rows?

why was this down voted??seems nothing wrong in this question.. — Dumb_Shock
– Dumb_Shock, Commented Aug 26, 2011 at 15:38

Doug · Accepted Answer · 2011-08-26 15:27:10Z

3

$sql ="SELECT * FROM table WHERE field1 LIKE '%$name%'";       
$result = mysql_query($sql);

$abc_output= "Data Fetched <br />"; 

while($row = mysql_fetch_array($result))
{
    $abc_output .="name: " . $row['name'] . "<br />" ;
    $abc_output .="age: " . $row['age'] . "<br />" ; 
    $abc_output .="sex: " .  $row['sex'] . "<br />" ; 
    $abc_output .="<hr />";
}

$abc_output .='<a href="abc.com"> Back to Main Menu</a>';
echo $abc_output;

edited Aug 26, 2011 at 15:27

answered Aug 26, 2011 at 15:20

Doug

6,4603 gold badges36 silver badges53 bronze badges

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

1 Comment

Ryan Matthews Over a year ago

Just to clarify for Ross, you set $abc_output initially outside of the while loop and just appended all of the rows to it. Otherwise it was overwriting the variable each time.

Marc B · Accepted Answer · 2011-08-26 15:21:13Z

2

$abc_output= "Data Fetched <br />";

This'll reset your string on every row you fetch. You need to concatenate the string everywhere within the loop, or you'll just delete all the previous work:

$abc_output .= "Data Fetched <br />";      
            ^--add this.

answered Aug 26, 2011 at 15:21

Marc B

362k44 gold badges433 silver badges508 bronze badges

Collectives™ on Stack Overflow

PHP help -- displaying multiple rows

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related