Posted by strawberry on 06/07/06 17:06

I'm trying to extend the script(s) provided at
www.phpriot.com/d/articles/client-side/sortable-lists-with-php-and-ajax/.
I'm struggling with the foreach syntax - I guess I'm just a dummy. I
still don't get it despite reading through http://uk.php.net/foreach.

Basically, there's a movie table (`movie_id`, `title`, `description`,
`ranking`).

and a function that gets the movies:

function getMovies()
{
$query = 'select movie_id, title, description from movies order
by ranking, lower(title)';
$result = mysql_query($query);

$movies = array();
while ($row = mysql_fetch_object($result)) {
$movies[$row->movie_id] = $row->title;
}

return $movies;
}


and here's where the titles are displayed on the page:

<ul id="movies_list" class="sortable-list">
<?php foreach ($movies as $movie_id => $title) { ?>
<li id="movie_<?= $movie_id ?>"><?= $title ?></li>
<?php } ?>
</ul>

For each movie what do I need to do to echo the movie description -
within the <li> statement for instance.

Hope that makes sense. Any help appreciated.

[Back to original message]