PHP/ MY SQL ERRORS

[beginnerphp]

Hi all, I have got a problem on my code since a few days.
The error message is
Parse error: syntax error, unexpected T_ELSE in /homes/2011/abkg063/html/Coursework/includes/bookDetails.php on line 40

how should I do?

<?php
include "database.php";

print_r($_GET);


$id = $_GET['id'];

$query = "SELECT * FROM `Book`, `Publisher` WHERE Book.publisher_id = Publisher.publisher_id AND Book.book_id=$id";
//$query = "SELECT * FROM `Book` WHERE book_id=$id";

$query2 = "SELECT * FROM `Author` WHERE Author.author_id = Author.author_id=$id";

//print $query;
//print $abkg063->error;

// perform the query
$result = $abkg063->query($query);
if (mysql_num_rows($result)>0) { //nbre d'enregistrements retournés par $query
  while ($row = $result->fetch_assoc()) {
      echo "<h1>This works: $row[title]</h1>";

           // second query
            $result2 = $abkg063->query($query2);
            if (mysql_num_rows($result2)>0) { //nbre d'enregistrements retournés par $query2
               while ($row2 = $result2->fetch_assoc()) {
                    echo " <h1>This works:'$row2[author]'</h1> ";
                 } //end while for $row2  

 ?>

    <h2> this also works: <?php echo $row['title']?></h2>
    <img src="/imgages/book_covers/<?php echo $row['book_id']?>.jpg" width=200 height=300 >

<?php
    } //fin while pour $row  

        print_r($row2);
        // Print out book details
        echo "OK";
 } else { 
        // No book found with such id
        echo "NOT FOUND!";
}

[planetphp]

i think this

<?php
} //fin while pour $row
print_r($row2);
// Print out book details
echo "OK";
} else {
// No book found with such id
echo "NOT FOUND!";
}

should be

<?php
//fin while pour $row
print_r($row2);
// Print out book details
echo "OK";
} else {
// No book found with such id
echo "NOT FOUND!";
}

[beginnerphp]

I tried this code and it does still the same error.

[cretaceous]

use a proper text editor with colour highlighting and it will show that you have a missing closing brace at the very end
}

it matches this opening brace :
if (mysql_num_rows($result)>0) {

You are not checking if the get id value exists before doing sql queries, which will cause errors if there is no id

As a quick hack you could add quotes to it in the query :
AND Book.book_id='$id'";

[bradgrafelman]

Your problem is caused by a missing '}'. For example, this closing '}' brace:

    } //fin while pour $row

actually matches up with the '{' opening brace on this line:

                if (mysql_num_rows($result2)>0) { //nbre d'enregistrements retournés par $query2 

Since the code comment suggests that it should have matched up with the while() opening brace, I'm guessing that the closing '}' brace should go before the one referenced above.