Display X rows sql using Php - 2D array

Question

<?php   //sql query which gets the data from database
$query = mysql_query ( "SELECT aaa,bbb,ccc,ddd,eee FROM xyz"); 
$row = mysql_fetch_row ($query);
?>

This query returns a 2-D array how to display that. This returns a part of table.

genesis · Accepted Answer · 2011-08-20 10:32:49Z

1

echo $row[0];
echo $row[1];
echo $row[2];
echo $row[3];
echo $row[4];

that's it. Or you can print_r whole array

print_r($row);

but to show all 5 lines you have in your DB, you should do it like

<?php 
$query = mysql_query ( "SELECT aaa,bbb,ccc,ddd,eee FROM xyz"); 
while($row = mysql_fetch_row ($query)){
         echo $row[0];
         echo $row[1];
         echo $row[2];
         echo $row[3];
         echo $row[4];
}
?>

edited Aug 20, 2011 at 10:32

answered Aug 20, 2011 at 10:07

genesis

51.1k20 gold badges99 silver badges127 bronze badges

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

7 Comments

Techmax Over a year ago

there are several values of aaa,bbb,ccc

Madara's Ghost Over a year ago

+1 for going to suggest print_r() you're ahead of me all day! leave some to me!! :P

genesis Over a year ago

@RikudoSennin: Lol. You're my enemy. I did 10k in 2 months. I can't allow you to be faster!!! (:p)

Techmax Over a year ago

it returns 5 rows and 5 columns

Madara's Ghost Over a year ago

:DD Actually I'm really taking my time here, but now that you said it, I MUST BE FASTER!! MADARA TIME SLOW ATTACK! </insanity>

|

Collectives™ on Stack Overflow

Display X rows sql using Php - 2D array

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related