Fetch all fields from all rows - MYSQL

Question

I understand this could appear alarming but bear with me.

I need to echo every field in every row in a table.

This is only an example - I have removed the HTML wrapped around it to improve readability.

$a = 1;

while ($a <= $count_rows) {
    $query = "SELECT col1, col2 etc.. FROM table WHERE `id`='$id'";

    $result = mysqli_query($con, $query);
    $i = 1; 

    while($i <= $count_fields) {
        $row = mysqli_fetch_array($result, MYSQL_NUM);
        echo "$row[$i]";
        $i++;       
    }

    $a++;
    $id = $a;
}

This only outputs the first field of every row? Why?

If I echo $row[2] I get nothing!

Did you know that you can retrieve multiple results using a single query? So using MySQL, you could just have a query of the form select * from table where id in ( 1,2,3,4,5,6 ) — bobobobo
– bobobobo, Commented May 15, 2013 at 14:47
Yeah i knew but anyway of doing it dynamically? I don't know how many rows i'm going to have you see — Edward
– Edward, Commented May 15, 2013 at 14:49

Your Common Sense · Accepted Answer · 2013-05-15 14:52:26Z

2

If I echo $row[2] I get nothing!

because it's actually third item
and there is some strange code interfering with $i variable

Anyway, to get every column from every row ou need a code like this

$query = "SELECT * FROM table";
$result = mysqli_query($con, $query);
while($row = mysqli_fetch_row($result)) {
    foreach ($row as $index => $value) {
        echo "$index => $value, ";
    }
    echo "<br>\n";
}

edited May 15, 2013 at 14:52

answered May 15, 2013 at 14:44

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

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

3 Comments

bobobobo Over a year ago

Every time he does $row = mysqli_fetch_array($result, MYSQL_NUM); he's only echo'ing $row[1]

Edward Over a year ago

+1 mysqli_fetch_row($result) instead of MYSQL_NUM Ill give it a try but it appears more logical, tend to shy away from foreach - it doesn't have any adverse affect on html inside the loop does it?

Edward Over a year ago

@bobobobo why? the $i = 1; is in the first loop not the second...?

Collectives™ on Stack Overflow

Fetch all fields from all rows - MYSQL

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related