PHP recordsets a multiple rows

[wadgey]

I'm tearing my hair out on what I think is a simple problem.

My query returns multiple rows. I know how many rows there are but what I want to do is to access each row in turn. Now I thought that my code puts the results into an array and I can access each element by:

$row_sections[x][y];

but something is going wrong.

Any ideas?

mysql_select_db($database_localhost, $localhost);
$query_sections = "SELECT * FROM sections WHERE sections.window_type = '$type'";
$sections = mysql_query($query_sections, $localhost) or die(mysql_error());
$row_sections = mysql_fetch_array($sections);
$totalRows_sections = mysql_num_rows($sections); 

[Fusen]

you seem to be missing a while loop to actually go through every row,

I'd recommend reading http://uk.php.net/manual/en/function...etch-array.php

[hxbro]

mysql_select_db($database_localhost, $localhost);
$query_sections = "SELECT * FROM sections WHERE sections.window_type = '$type'";
$sections = mysql_query($query_sections, $localhost) or die(mysql_error());
$totalRows_sections = mysql_num_rows($sections);

// loop through the results
while ($row_sections = mysql_fetch_array($sections))
{
    // $row_sections contains the row
} 

[wadgey]

thanks. I found and used this:

mysql_result($sections, $i, "section_width_type"

it seems to work. What exactly does this do?