Is it possible to execute big SQL query in Hibernate?

PHP and SQL question...?

• How do I: A) Place a link to another PHP file on my BookISBN's? The file name is moreInfo.php B) Get the table headers to work? <?php include ( 'dbconnect.php' ); // connect to the database // Make up an SQL query (put into variable) $bookSQL = "SELECT bookISBN, bookTitle, bookYear, catID, bookPrice FROM nbc_book ORDER BY bookTitle"; // execute the SQL query $rsBooks = mysql_query( $bookSQL )or die ( mysql_error() ); // Loop through the record set of data returned by the query and display it on the screen. echo "<table border=\"1\">"; echo"<tr>"; echo "<th><strong>BookISBN</strong></th>"; echo "<th><strong>Title</strong></th>"; echo "<th>Year</th>"; echo "<th>Catalogue ID</th>"; echo "<th>Price</th>"; echo "</tr>"; while ( $row = mysql_fetch_assoc( $rsBooks ) ) { echo "<tr><td>" . $row['bookISBN'] . "</td><td>" . $row['bookTitle'] . "</td><td>" . $row ['bookYear'] . "</td><td>" . $row ['catID'] . "</td><td>" . $row ['bookPrice'] . "</td></tr>"; } echo "</table>"; mysql_free_result ( $rsBooks ); ?> I don't know what I'm doing wrong :/

• Answer:

  try debugging it with these steps: 1) echo $bookSQL & paste this into an SQL tool like MSQL Workbench to see if it is without errors 2) echo $rsBooks (or print_r $rsBooks) to see if it really is filled with content. 3) try using mysql_fetch_row instead of mysql_fetch_assoc Missing the opening & closing of the database, so I can't really say anything about it, but I guess the connection fails.