RE: [PHP] how to extract fields from associative array into different variables

On 15 June 2009 18:07, PJ advised:

> Is there an easier or simpler way to do this?
> code:
> 
> $sql = "SELECT first_name, last_name, book_author.ordinal
>       FROM author, book_author
>       WHERE book_author.bookID = $idIN && book_author.authID =
author.id
> ORDER BY ordinal";
> 
>     $author = array();
>     if ( ( $results = mysql_query($sql, $db) ) !== false ) {
>         while ( $row = mysql_fetch_array($results, MYSQL_ASSOC) ) {

>         $author[] = $row; }
>     }
> $numrows = mysql_num_rows($results);
> switch ($numrows)
> {
> case 5:
>   $first_nameIN = $author[0]['first_name'];
>   $last_nameIN = $author[0]['last_name'];
>   $first_name2IN = $author[1]['first_name'];
>   $last_name2IN = $author[1]['last_name'];
>   $first_name3IN = $author[2]['first_name'];
>   $last_name3IN = $author[2]['last_name'];
>   $first_name4IN = $author[3]['first_name'];
>   $last_name4IN = $author[3]['last_name'];
>   $first_name5IN = $author[4]['first_name'];
>   $last_name5IN = $author[4]['last_name'];
>   break;
> case 4:
>   $first_nameIN = $author[0]['first_name'];
>   $last_nameIN = $author[0]['last_name'];
> snip....

Why not just use $author[0]['first_name'] instead of $first_nameIN (and
so on) in the rest of your code?

Cheers!

Mike

 --
Mike Ford,  Electronic Information Developer,
C507, Leeds Metropolitan University, Civic Quarter Campus, 
Woodhouse Lane, LEEDS,  LS1 3HE,  United Kingdom
Email: [email protected]
Tel: +44 113 812 4730

   


To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm