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?
>
>
I probably should have explained in greater detail: there are up to 5
authors for each book in the db and the insert and update fields in the
form input needs the different variables as each author is treated
separately. I'm not sure if there is another way to do it.
--
Hervé Kempf: "Pour sauver la planète, sortez du capitalisme."
-------------------------------------------------------------
Phil Jourdan --- pj@xxxxxxxxxxxxx
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
