krillin82
-
Posts
1 -
Joined
-
Last visited
Never
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
Simple Querry -PHP/MYSQL Newb
in Microsoft SQL - MSSQL
Posted
I am trying to make a small php form/mysql application that enters in kids and problems with discipline. I have been working in dreamweaver for the most part and I can create and list the records but I am having problems with pulling all the records for a kid based on his name passed on from a previous page stored in a value called recordID. I'm sure this is a really newb question but for some reason I am having a hard time with it. Here's kind of what I have going on now. Thanks for any help.
<?php require_once('Connections/discipline.php'); ?><?php
mysql_select_db($database_discipline, $discipline);
$query_Incidents = "SELECT * FROM incident_log WHERE 'student_name' = 'recordID'";
$Incidents = mysql_query($query_Incidents, $discipline) or die(mysql_error());
$row_Incidents = mysql_fetch_assoc($Incidents);
$totalRows_Incidents = mysql_num_rows($Incidents);
$maxRows_DetailRS1 = 10;
$pageNum_DetailRS1 = 0;
if (isset($_GET['pageNum_DetailRS1'])) {
$pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];
}
$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1;
mysql_select_db($database_discipline, $discipline);
$recordID = $_GET['recordID'];
$query_DetailRS1 = "SELECT * FROM incident_log WHERE student_name = '$recordID'";
$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1);
$DetailRS1 = mysql_query($query_limit_DetailRS1, $discipline) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);
if (isset($_GET['totalRows_DetailRS1'])) {
$totalRows_DetailRS1 = $_GET['totalRows_DetailRS1'];
} else {
$all_DetailRS1 = mysql_query($query_DetailRS1);
$totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1);
}
$totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<table border="1" align="center">
<tr>
<td>ID</td>
<td><?php echo $row_DetailRS1['ID']; ?> </td>
</tr>
<tr>
<td>enrollment_grade</td>
<td><?php echo $row_DetailRS1['enrollment_grade']; ?> </td>
</tr>
<tr>
<td>student_name</td>
<td><?php echo $row_DetailRS1['student_name']; ?> </td>
</tr>
<tr>
<td>enrichment_faculty</td>
<td><?php echo $row_DetailRS1['enrichment_faculty']; ?> </td>
</tr>
<tr>
<td>incident type</td>
<td><?php echo $row_DetailRS1['incident_type']; ?> </td>
</tr>
</table>