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: m.ford@leedsmet.ac.uk 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