I am having a problem with this page I am writing in DWMX2k4
connecting to MySQL 5 and PHP 5 databse. I am a newbie and can't
interprut the error message.
<?php require_once('Connections/DBconn.php'); ?>
<?php
$maxRows_unit_keyword_search = 15;
$pageNum_unit_keyword_search = 0;
if (isset($_GET['pageNum_unit_keyword_search'])) {
$pageNum_unit_keyword_search = $_GET['pageNum_unit_keyword_search'];
}
$startRow_unit_keyword_search = $pageNum_unit_keyword_search *
$maxRows_unit_keyword_search;
$colname_unit_keyword_search = "1";
if (isset($_GET['Name'])) {
$colname_unit_keyword_search = (get_magic_quotes_gpc()) ? $_GET
['Name'] : addslashes($_GET['Name']);
}
mysql_select_db($database_DBconn, $DBconn);
$query_unit_keyword_search = sprintf("SELECT * FROM tbl_unit_plan
WHERE Name = '%s' ORDER BY Name ASC", $colname_unit_keyword_search);
$query_limit_unit_keyword_search = sprintf("%s LIMIT %d, %d",
$query_unit_keyword_search, $startRow_unit_keyword_search,
$maxRows_unit_keyword_search);
$unit_keyword_search = mysql_query($query_limit_unit_keyword_search,
$DBconn) or die(mysql_error());
$row_unit_keyword_search = mysql_fetch_assoc($unit_keyword_search);
if (isset($_GET['totalRows_unit_keyword_search'])) {
$totalRows_unit_keyword_search = $_GET
['totalRows_unit_keyword_search'];
} else {
$all_unit_keyword_search = mysql_query($query_unit_keyword_search);
$totalRows_unit_keyword_search = mysql_num_rows
($all_unit_keyword_search);
}
$totalPages_unit_keyword_search = ceil($totalRows_unit_keyword_search/
$maxRows_unit_keyword_search)-1;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-
transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml";>
<table border="0">
<tr>
<td>Id</td>
<td>Name</td>
<td>Craeted By</td>
<td>Grade For</td>
<td>Ready To Use For Class</td>
<td>General Description</td>
<td>Materials Needed</td>
<td>UnitTimeline</td>
<td>Use</td>
<td>Unit Length</td>
<td>Overview & Purpose</td>
<td>Teacher Objectives</td>
<td>Student Objectives</td>
<td>Teacher Information</td>
<td>Student Information</td>
<td>Teacher Verification</td>
<td>Student Verification</td>
<td>Teacher Activity</td>
<td>Student Activity</td>
<td>Teacher Summary</td>
<td>Student Summary</td>
<td>General Notes</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_unit_keyword_search['Id']; ?></td>
<td><?php echo $row_unit_keyword_search['Name']; ?></td>
<td><?php echo $row_unit_keyword_search['Craeted By']; ?></td>
<td><?php echo $row_unit_keyword_search['Grade For']; ?></td>
<td><?php echo $row_unit_keyword_search['Ready To Use For
Class']; ?></td>
<td><?php echo $row_unit_keyword_search['General Description']; ?
></td>
<td><?php echo $row_unit_keyword_search['Materials Needed']; ?
></td>
<td><?php echo $row_unit_keyword_search['UnitTimeline']; ?></td>
<td><?php echo $row_unit_keyword_search['Use']; ?></td>
<td><?php echo $row_unit_keyword_search['Unit Length']; ?></td>
<td><?php echo $row_unit_keyword_search['Overview & Purpose']; ?
></td>
<td><?php echo $row_unit_keyword_search['Teacher Objectives']; ?
></td>
<td><?php echo $row_unit_keyword_search['Student Objectives']; ?
></td>
<td><?php echo $row_unit_keyword_search['Teacher Information']; ?
></td>
<td><?php echo $row_unit_keyword_search['Student Information']; ?
></td>
<td><?php echo $row_unit_keyword_search['Teacher Verification']; ?
></td>
<td><?php echo $row_unit_keyword_search['Student Verification']; ?
></td>
<td><?php echo $row_unit_keyword_search['Teacher Activity']; ?
></td>
<td><?php echo $row_unit_keyword_search['Student Activity']; ?
></td>
<td><?php echo $row_unit_keyword_search['Teacher Summary']; ?
></td>
<td><?php echo $row_unit_keyword_search['Student Summary']; ?
></td>
<td><?php echo $row_unit_keyword_search['General Notes']; ?></td>
</tr>
<?php } while ($row_unit_keyword_search = mysql_fetch_assoc
($unit_keyword_search)); ?>
</table>
</body>
</html>
<?php
mysql_free_result($unit_keyword_search);
?>
PHP Data object relational mapping generator
http://www.metastorage.net/
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-objects/
<*> To unsubscribe from this group, send an email to:
php-objects-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
