Ford, Mike wrote:
> 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?
Duh, I think I learned something here... it works! Thank you a
zillion.... ;-)
--
Hervé Kempf: "Pour sauver la planète, sortez du capitalisme."
-------------------------------------------------------------
Phil Jourdan --- [email protected]
http://www.ptahhotep.com
http://www.chiccantine.com/andypantry.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
