While Loop Problem

[RRWD]

So I'm working on a bit of code that is supose to grab information and then run a loop. I've written something like this in the past but for some reason I cannot get it to work propery. I know I'm most likely missing something small but I can't find it. A fresh pair of eyes couldn't hurt. When I run it I get a blank page no error message.

 

$query = "SELECT * FROM tbl_chapters ";
$query .= "WHERE State = 'CA' ";
$result_set = mysql_query($query, $connection);
confirm_query($result_set);
$chapter_set = mysql_fetch_array($result_set);
return $chapter_set;
           

while ($row = mysql_fetch_array($chapter_set)) {
        echo $row["Chapter"];
}

 

Anyone?

[Philip]

Well.. you're returning (return $chapter_set;) before the while loop.

[RRWD]

it was set up like that because it was on a function.php page, which is what is needed. Right?

 

I did comment it out and change it to result_set and it looped so we are getting somewhere.

[_EmilsM]

$reurnArray = Array();
while ($row = mysql_fetch_array($chapter_set)) {
        $returnArray[] = $row["Chapter"];
}
return $returnArray;
 

[web_craftsman]

_EmilsM , mysql_fetch_assoc is a better function for this.  If you don't consider, of course, that mysql_ extension is deprecated by now...