Can't find the problem (no error message)!
Posted on
16th Feb 2014 07:03 pm by
admin
OK, here's the deal. This code is really weirdly formatted (sorry!) and hard to understand, so I'm going to try and make it as easy as possible. Here's a breakdown of what the user should do:
1. The user sees a list of his classes (stored in the classes table in the DB). He picks one.
Code: [Select]$instructor = $_COOKIE['USERNAME'];
$query = ("SELECT * FROM classes WHERE instructor='$instructor'");
$sql = mysql_query($query) or die(mysql_error());
echo '<form action="'.$_SERVER['PHP_SELF'].'" method="post">
<table border="1" cellspacing="2" cellpadding="3">';
while ($row = mysql_fetch_array($sql))
{
echo '<tr><td>';
echo $row['id'];
echo '</td><td>';
echo $row['session'];
echo '</td><td>';
echo $row['day'];
echo '</td><td>';
echo $row['time'];
echo '</td><td>';
echo $row['level'];
echo '</td><td>';
$class_id = $row['id'];
echo '<input type = "hidden" name = "class_id" value = "'.$class_id.'" />';
echo '<input type = "submit" name = "pickclass" value = "Run" /></form>';
echo '</td></tr>';
}
echo '</table>';
2. The user is shown a list of the students in that class. He picks one.
Code: [Select] if (isset($_POST['pickclass'])) {
echo '<table>';
$class_id = $_POST['class_id'];
echo '<form action="'.$_SERVER['PHP_SELF'].'" method="post">';
echo '<tr><td><strong>Instructor: </td></tr></table>';
echo $_COOKIE['USERNAME'];
$instructor = $_COOKIE['USERNAME'];
echo '<table border="1" cellspacing="2" cellpadding="3">';
echo '<tr><td>ID</td><td>First</td><td>Last</td><td>Gender</td><td>Level</td></tr>';
$query = ("SELECT * FROM `students` WHERE classid='$class_id' LIMIT 0, 30");
$sql = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($sql)) {
echo '<tr><td>';
echo $row['id'];
echo '</td><td>';
echo $row['fname'];
echo '</td><td>';
echo $row['lname'];
echo '</td><td>';
echo $row['gender'];
echo '</td><td>';
echo $row['level'];
echo '</td><td>';
echo '<input type = "hidden" name = "id" value = "'.$row['id'].'" />';
echo '<input type = "hidden" name = "fname" value = "'.$row['fname'].'" />';
echo '<input type = "hidden" name = "lname" value = "'.$row['lname'].'" />';
echo '<input type = "hidden" name = "gender" value = "'.$row['gender'].'" />';
echo '<input type = "hidden" name = "level" value = "'.$row['level'].'" />';
echo '<input type = "submit" name = "submit" value = "GO!" /></td></tr></table></form>';
Here's the problem: the only thing showing up under step two is the table headers (i.e. First, Last, etc.)
I don't know why. I feel like it's a tiny problem but I can't find it! Help!
----
In reality, the code looks like this. Don't hurt me!
Code: [Select]//something else comes before this
else
{
if (isset($_POST['pickclass'])) {
echo '<table>';
$class_id = $_POST['class_id'];
echo '<form action="'.$_SERVER['PHP_SELF'].'" method="post">';
echo '<tr><td><strong>Instructor: </td></tr></table>';
echo $_COOKIE['USERNAME'];
$instructor = $_COOKIE['USERNAME'];
echo '<table border="1" cellspacing="2" cellpadding="3">';
echo '<tr><td>ID</td><td>First</td><td>Last</td><td>Gender</td><td>Level</td></tr>';
$query = ("SELECT * FROM `students` WHERE classid='$class_id' LIMIT 0, 30");
$sql = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($sql)) {
echo '<tr><td>';
echo $row['id'];
echo '</td><td>';
echo $row['fname'];
echo '</td><td>';
echo $row['lname'];
echo '</td><td>';
echo $row['gender'];
echo '</td><td>';
echo $row['level'];
echo '</td><td>';
echo '<input type = "hidden" name = "id" value = "'.$row['id'].'" />';
echo '<input type = "hidden" name = "fname" value = "'.$row['fname'].'" />';
echo '<input type = "hidden" name = "lname" value = "'.$row['lname'].'" />';
echo '<input type = "hidden" name = "gender" value = "'.$row['gender'].'" />';
echo '<input type = "hidden" name = "level" value = "'.$row['level'].'" />';
echo '<input type = "submit" name = "submit" value = "GO!" /></td></tr></table></form>';
No comments posted yet
Your Answer:
Login to answer
193 44
Other forums
FILTER_CALLBACK -- Files?
Hi All,
I'm using the php filter functions to validate my form data. For custom filters, I'm
Mass activity scheduling
Hi experts,
Im facing some problems to deal with mass activity jobs.
When I run some
Word Trimming
Hi Guys & Gals!!
Hope you are all ok....
I need some help with the following
HELP with mysql_real_escape_string
I'm looking to remove apostrophes completely when someone enters lyrics but don't have a clue how to
TemplatePower & AJAX
Hi all,
I'm currently implementing some AJAX features in my PHP-framework (which is b
ctype() validation - allowing illegal characters
Hello,
I use ctype() to filter and validate a user form. However, I am trying to allow certain c
Using Curl_multi for processing multiple URLs
Hi,
I am at a loss as to how to implement this. I would like to be able to automatically assi
Email Form Syntax Issue
I need the TO: in email to display To: CEO instead of To: abc@mail.com
How to alter the scri
Secure pages Sessions vs. Cookies & session_destroy() help
Im new here and new to PHP, I hope you can help me with some questions.
Im writing my web ap
parse error
Parse error: syntax error, unexpected '[', expecting ')' in /Users/admin/Sites/phptest/array.php on