Do you have display_errors ON in your php.ini ??
---John Holmes...
----- Original Message -----
From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
To: "PHP General" <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 3:24 PM
Subject: [PHP] Lost, need help debuggin....
> Hi,
>
> I am trying to debugging this script. But, I can see what the issue is, it
> not listing errors on any of the mysql stuff but this what I see when I
view
> source....
>
> --------------------------------------------------------------------------
--
>
>
>
>
> --------------------------------------------------------------------------
--
>
> Here is the code.
>
> --------------------------------------------------------------------------
--
>
> <html>
> <head>
> <title>Browse A Movie in My Movie Database</title>
> <meta name="generator" content="BBEdit 6.1.2">
> </head>
> <body>
>
> <?php
>
> //How many should be displayed on per page
>
> $display_number = 25;
>
> //Connect to the database
>
> $db_connection = mysql_connect ('localhost', 'user', 'gateway') or die
> ('Could not connect');
> $db_select = mysql_select_db ('media') or die ("Couldn't not access
> database");
>
> //If we don't know how many pages there are, make that calculation.
>
> print "before the first if";
>
> if (!isset($num_pages)) {
>
>
> // Determine the query.
>
> if(isset($letter)) { // Browsing a particular letter or the whole
> shebang?
>
> $query1 = "SELECT library.title FROM media.library WHERE library.title
> LIKE '$letter%' ORDER BY library.title ASC";
>
> } else {
>
> $query1 = "SELECT library.title FROM media.library ORDER BY
> library.title ASC";
>
> }
>
> //Query the database
>
> $query_result1 = @mysql_query ($query1) or die ("Could not run
query");
>
>
> //Calculate the number of pages required.
>
> $num_results = @mysql_num_row ($query_result);
> if ($num_results > $display_number) {
> $num_pages = ceil ($num_results/$display_number);
>
> } elseif ($num_results > 0) {
>
> $num_pages = 1;
>
> } else {
>
> echo 'There are no movies in this selection';
>
> }
>
> $start = 0; // Current at item 0
>
>
> }
>
> if(isset($letter)) { // Browsing a particular letter or the whole shebang?
>
> $query = "SELECT library.title FROM media.library WHERE library.title
> LIKE '$letter%' ORDER BY library.title ASC LIMIT $start, $display_number";
>
> } else {
>
> $query = "SELECT library.title FROM media.library ORDER BY
library.title
> ASC LIMIT $start, $display_number";
>
> }
>
>
> // Table that shows movies...
>
> echo "<table align='center' cellpadding='2' cellspacing='2' border='1'>";
> echo "<tr align='center'>";
> echo "<td align='center'><b>Title</b></td>";
> echo "</tr>";
>
> // Print My list
>
> $query_result = @mysql_query ($query);
>
> while ($row = @mysql_fetch_array ($query_result)) {
>
> print "<tr align='center'>";
> print "<td align='center'><i><a
> href='testlist.php?row[title]'>$row[title]</a></i></td>";
> print "</tr>";
>
> }
>
> // Make the links to others pages, if nessessary.
>
> if ($num_pages > 1) {
>
> print "<tr align='center'>";
> print "<td align = 'center' colspan = '2'>";
>
> // Determine what page the script is on.
>
> if ($start == 0) {
> $current_page = 1;
>
> } else {
>
> $current_page = ($start/$display_number) + 1;
>
> }
>
> // If it's not the make a back button...
>
> If($start !=0) {
> echo '<a href="browse_movie.php?start=' .($start -
$display_number)
> . '&num_pages=' .
> $num_pages . '&lettter' . $letter . '">Back</a> ';
> }
>
> // Make all the numbered pages.
>
> for ($i = 1; $i <= $num_pages; $i++) {
> $next_start = $start + $display_number;
> if ($i != $current_page) {
>
> // Don't link the current page
>
> print '<a href="browse_movie?start=' . (($display_number *
($i-1)))
> .
> '&num_pages=' . $num_pages . '$letter=' .$letter . '">' .$i .
'</a>
> ';
>
> } else {
>
> echo $i . ' ';
>
> }
>
> }
>
> // If it's not the last page, make a next buttton.
>
> if($current_page !=$num_pages) {
> print '<a href="browse_movie?start=' . ($start + $display_number)
.
> '&num_pages=' .
> $num_pages . '&letter=' . $letter . '">Next</a> ';
>
>
> }
>
> print "</td>";
> print "</tr>";
>
>
> }
>
>
> ?>
>
> </table>
> </body>
> </html>
>
>
> --------------------------------------------------------------------------
--
>
> Thanks a head of time if you can show the error(s) in my code.
>
> Chuck Payne
> Magi Design and Support
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
