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@xxxxxxxxxxxxxx
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
