Looping through mysql_fetch_array in PHP

Question

So I have the following:

$i = 0;
$records = mysql_num_rows($sections_query);
$row_sections = mysql_fetch_array($sections_query);
    foreach ($row_sections as $value) {
    echo $value . "<br />";
}

The value of $records becomes 4 after execution and the DB has 2 columns per row. The first column value is 'section_id' and the second is 'section_name'.

I want to write a loop that will print out the value of 'section_name' like-

echo "<h3>" . $row_sections[section_name]; . "</h3>";

within the loop, so basically I'll have 3 h3's each containing the 4 different values in 'section_name'

And maybe foreach() isn't the best loop to use? Anyway, I'm confused.

Hope that makes sense, and thanks in advance for the help!

Tyler Carter · Accepted Answer · 2009-07-30 18:19:03Z

12

$i = 0;
$records = mysql_num_rows($sections_query);
while($row_sections = mysql_fetch_array($sections_query))
{
    echo "<h3>" . $row_sections['section_name'] . "</h3>";
}

That will go through each row and print the Section Name.

edited Jul 30, 2009 at 18:19

answered Jul 30, 2009 at 17:56

Tyler Carter

61.7k22 gold badges133 silver badges153 bronze badges

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

1 Comment

Marty Over a year ago

You left out a { and there's a semi-colon in the echo line out of place but, when it worked fine once I fixed that. Thanks!!

Collectives™ on Stack Overflow

Looping through mysql_fetch_array in PHP

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related