Errata: Ch. 6, Page 157

drupalmeister · June 4th, 2009, 12:05 AM

Hi,

On page 157 (and the few follwing pages, based on the same code) there is this code:

PHP Code:


			
while ($row = mysql_fetch_assoc($result)) {
       foreach ($row as $value) {
           echo '<option value"' . $row['movietype_id'] . '">';
           echo $row['movietype_label'] . '</option>';
       }
    }

Now, I have no idea why we need this foreach statement, if we already fetched the row, and we are referring to it using array syntax.

aformoftruth · January 24th, 2010, 05:33 AM

I had this error too and i its not in errata but it should be.

Thanks for solving this i thought the 'foreach' statements looked unnecessary.

Truth

bopjo1 · September 27th, 2010, 10:08 AM

I just ran into this problem today. The foreach statement results in 2 listings of each item. Kinda disturbing they'd put this in the book. Don't they know better?

By the way, where *is* the errata for this book? The only one I found on this site deals with minor typos and grammar, not code.

hozdaman · September 27th, 2010, 04:48 PM

So instead of the foreach what should it be? please help. THansk.

bopjo1 · September 27th, 2010, 04:51 PM

Just delete this:

foreach ($row as $value) {

and this:

}

Keep the echo stuff in between.

hozdaman · September 27th, 2010, 04:59 PM

Thanks for your help!

bopjo1 · September 27th, 2010, 05:33 PM

you're welcome mate.