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
