Posted by ZeldorBlat on 06/07/06 17:33

strawberry wrote:
> 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.

In the getMovies() function, change the while loop to something like
this:

while ($row = mysql_fetch_object($result)) {
$movies[] = $row;
}

And when you display them:

foreach($movies as $movie) {
//$movie->movie_id is the movie_id
//$movie->title is the title
//$movie->description is the description
}

[Back to original message]