fetch first mysql_通过PHP mysql_fetch_array循环

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 . "
";

}

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 "

" . $row_sections[section_name]; . "

";

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!

解决方案$i = 0;

$records = mysql_num_rows($sections_query);

while($row_sections = mysql_fetch_array($sections_query))

{

echo "

" . $row_sections['section_name'] . "

";

}

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