DarkPrince2005 Posted September 19, 2007 Share Posted September 19, 2007 I have two pages one that lists all the fields in the database with a button that should take you to the second page and only display the chosen record, but it isn't displaying anything. nehw 3.php <? mysql_connect("localhost","root",""); mysql_select_db("npa"); // Begin your table outside of the array echo "<html><head><title></title><link rel='stylesheet' href='stylesheet.css' type='text/css'> <style> a:link{font-family:'Times New Roman'; font-size:10pt; color:'#ffffff'; font-weight:700; text-decoration:none; } a:visited{font-family:'Times New Roman'; font-size:10pt; color:'#ffffff'; font-weight:700; text-decoration:None; } a:hover{font-family:'Times New Roman'; font-size:10pt; text-decoration:none; color:'#B37A04'; font-weight:700; } a:active{font-family:'Times New Roman'; font-size:10pt; color:'#ffffff'; font-weight:700; } </style></head><body bgcolor='#FDCC67' topmargin='0' bottommargin='0' leftmargin='0' rightmargin='0'> <center><table width='100%' height='100%' cellpadding='0' cellspacing='0' border='0'> <tr><td valign='top' width='140' bgcolor='#000000'><br> <a href='home.html'>Home</a><br><br> <a href='view.php'>View Records</a><br><br> <a href='add.html'>Add Record</a><br><br> <a href='edit1.php'>Edit Record</a><br><br> <a href='delete1.php'>Delete Record</a><br><br> <a href='report.php'>View Report</a><br><br> <a href='q.php'>Query Report</a><br><br> <a href='search1.php'>Search</a></td><td valign='top' align='center'><table><tr> <td align='right' valign='top'></td></tr> <tr><td align='center' valign='top'><h1>Disciplinaries: Age Analysis</h1></td></tr> <tr><td align='center' valign='top'></td></tr> <tr><td valign='top'><br><form action='view333333.php' method='post'><table cellpadding='2' border='0' cellspacing='0'> <tr bgcolor='#ff9900' height='50'> <td> </td><td> </td> <td><b>File_Ref</b></td> <td> </td><td> </td> <td><b>First Name</b></td> <td> </td><td> </td> <td><b>Last Name</b></td> <td> </td><td> </td> <td><b>Persal Number</b></td> <td> </td><td> </td> <td><b>Occupation</b></td> <td> </td><td> </td> <td><b>Unit</b></td> <td> </td><td> </td> <td><u><b>Region</b></td> <td> </td><td> </td> <td><u><b>Age ( Days )</b></td> <td> </td><td> </td> <td> </td><td> </td></tr>"; // Define your colors for the alternating rows $color1 = "#FFBB55"; $color2 = "#CCEEFF"; $row_count = 0; // Perform an statndard SQL query: $date1= mysql_query("SELECT datediff(curdate(),Date_Recieved) from dis;"); $r = mysql_query ("UPDATE dis SET Date_Added=(SELECT datediff(curdate(),Date_Recieved));"); $q = mysql_query("SELECT * from dis order by Date_Added desc"); // We are going to use the "$row" method for this query. This is just my preference. while ($row = mysql_fetch_assoc($q)) { $file_ref=$row["File_Ref"]; $ef=$row["Employee_Firstname"]; $el=$row["Employee_Lastname"]; $persal=$row["Persal_Number"]; $occ=$row["Occupation"]; $unit=$row["Unit"]; $region=$row["Region"]; $date_added=$row["Date_Added"]; /* Now we do this small line which is basically going to tell PHP to alternate the colors between the two colors we defined above. */ $row_color = ($row_count % 2) ? $color1 : $color2; // Echo your table row and table data that you want to be looped over and over here. echo " <tr> <td bgcolor='$row_color'> </td> <td bgcolor='$row_color'> </td> <td align='left' bgcolor='$row_color' height='40'><input type='hidden' name='duh' value='$row[File_Ref]'>$row[File_Ref]</td> <td bgcolor='$row_color'> </td> <td bgcolor='$row_color'> </td> <td align='left' bgcolor='$row_color'>$ef</td> <td bgcolor='$row_color'> </td> <td bgcolor='$row_color'> </td> <td align='left' bgcolor='$row_color'>$el</td> <td bgcolor='$row_color'> </td> <td bgcolor='$row_color'> </td> <td align='left' bgcolor='$row_color'>$persal</td> <td bgcolor='$row_color'> </td> <td bgcolor='$row_color'> </td> <td align='left' bgcolor='$row_color'>$occ</td> <td bgcolor='$row_color'> </td> <td bgcolor='$row_color'> </td> <td align='left' bgcolor='$row_color'>$unit</td> <td bgcolor='$row_color'> </td> <td bgcolor='$row_color'> </td> <td align='left' bgcolor='$row_color'>$region</td> <td bgcolor='$row_color'> </td> <td bgcolor='$row_color'> </td> <td align='left' bgcolor='$row_color'>$date_added</td> <td bgcolor='$row_color'> </td> <td bgcolor='$row_color'> </td> <td bgcolor='$row_color'><input type='submit' value=' View '></td> <td bgcolor='$row_color'> </td></tr>"; // Add 1 to the row count $row_count++; } // Close out your table. echo "</table></form>"; ?> view333333.php <?php mysql_connect("localhost","root",""); mysql_select_db("npa"); $q = mysql_query("SELECT * from dis where File_Ref like '$_POST[duh]'"); while ($row = mysql_fetch_assoc($q)) $ef=$row["Employee_Firstname"]; $el=$row["Employee_Lastname"]; $persal=$row["Persal_Number"]; $occ=$row["Occupation"]; $level=$row["Level"]; $gender=$row["Gender"]; $race=$row["Race"]; $unit=$row["Unit"]; $region=$row["Region"]; $date_added=$row["Date_Added"]; { echo "<html><head><title></title><link rel='stylesheet' href='stylesheet.css' type='text/css'> <style> a:link{font-family:'Times New Roman'; font-size:10pt; color:'#ffffff'; font-weight:700; text-decoration:none; } a:visited{font-family:'Times New Roman'; font-size:10pt; color:'#ffffff'; font-weight:700; text-decoration:None; } a:hover{font-family:'Times New Roman'; font-size:10pt; text-decoration:none; color:'#B37A04'; font-weight:700; } a:active{font-family:'Times New Roman'; font-size:10pt; color:'#ffffff'; font-weight:700; } </style></head><body bgcolor='#FDCC67' topmargin='0' bottommargin='0' leftmargin='0' rightmargin='0'> <center><table width='100%' height='100%' cellpadding='0' cellspacing='0' border='0'> <tr><td valign='top' width='140' bgcolor='#000000'><br> <a href='home.html'>Home</a><br><br> <a href='view.php'>View Records</a><br><br> <a href='add.html'>Add Record</a><br><br> <a href='edit1.php'>Edit Record</a><br><br> <a href='delete1.php'>Delete Record</a><br><br> <a href='report.php'>View Report</a><br><br> <a href='q.php'>Query Report</a><br><br> <a href='search1.php'>Search</a></td><td valign='top' align='center'><table><tr> <td align='right' valign='top'><form action='search2.php' method='post'><b>Search by Persal Number:</b> <input type='text' name='search'> <input type='submit' value='Search'></form></td></tr> <tr><td align='center' valign='top'><h1>View Disciplinary Records</h1></td></tr> <tr><td align='center' valign='top'></td></tr> <tr><td align='center' valign='top'><br><center> <table cellpadding='0' border='0' cellspacing='0'><tr> <td valign='top'><table width='400'> <tr><td><b>File Ref</td><td> </td> <td>".$row['File_Ref']."</td></tr> <tr><td><b>Employee Firstname</td><td> </td> <td>$el</td></tr> <tr><td><b>Employee Lastname</td><td> </td> <td>$row[Employee_Lastname]</td></tr> <tr><td><b>Persal Number</td><td> </td> <td>$row[Persal_Number]</td></tr> <tr><td><b>Occupation</td><td> </td> <td>$row[Occupation]</td</tr> <tr><td><b>Level</td><td> </td> <td>$row[Level]</td</tr> <tr><td><b>Gender</td><td> </td> <td>$row[Gender]</td</tr> <tr><td><b>Race</td><td> </td> <td>$row[Race]</td</tr> <tr><td><b>Suspension</td><td> </td> <td>$row[suspensions]</td</tr> <tr><td><b>Period</td><td> </td> <td>$row[Period]</td></tr> <tr><td><b>Date Recieved</td><td> </td> <td>$row[Date_Recieved]</td</tr> <tr><td><b>Unit</td><td> </td> <td>$row[unit]</td</tr> <tr><td><b>Region</td><td> </td> <td>$row[Region]</td</tr> <tr><td><b>Date Of DC</td><td> </td> <td>$row[Date_Of_DC]</td</tr> <tr><td><b>Status</td><td> </td> <td>$row[status]</td</tr> <tr><td><b>Category</td><td> </td> <td>$row[Category]</td></tr> <tr><td><b>Outcome</td><td> </td> <td>$row[Outcome]</td></tr></table></td><td> </td><td valign='top'><table width='400'> <tr><td valign='top'><b>Status Report</td><td> </td> <td width='250'>$row[status_Report]</td></tr> <tr><td valign='top'></td><td> </td> <td></td></tr> <tr><td valign='top'><b>Age</td><td> </td> <td>$row[Date_Added] Days</td></tr> </table></table></td></tr></table></td></tr></table> </body>"; }; echo mysql_num_rows($r); ?> Link to comment https://forums.phpfreaks.com/topic/69858-solved-form-post/ Share on other sites More sharing options...
JJohnsenDK Posted September 19, 2007 Share Posted September 19, 2007 i think your problem is in your while loop in the view.php file: <?php $q = mysql_query("SELECT * from dis where File_Ref like '$_POST[duh]'"); while ($row = mysql_fetch_assoc($q)) $ef=$row["Employee_Firstname"]; $el=$row["Employee_Lastname"]; $persal=$row["Persal_Number"]; $occ=$row["Occupation"]; $level=$row["Level"]; $gender=$row["Gender"]; $race=$row["Race"]; $unit=$row["Unit"]; $region=$row["Region"]; $date_added=$row["Date_Added"]; { ?> you need to put the variables into the embracer, like this: <?php $q = mysql_query("SELECT * from dis where File_Ref like '$_POST[duh]'"); while ($row = mysql_fetch_assoc($q)) { $ef=$row["Employee_Firstname"]; $el=$row["Employee_Lastname"]; $persal=$row["Persal_Number"]; $occ=$row["Occupation"]; $level=$row["Level"]; $gender=$row["Gender"]; $race=$row["Race"]; $unit=$row["Unit"]; $region=$row["Region"]; $date_added=$row["Date_Added"]; ?> Link to comment https://forums.phpfreaks.com/topic/69858-solved-form-post/#findComment-350924 Share on other sites More sharing options...
DarkPrince2005 Posted September 19, 2007 Author Share Posted September 19, 2007 It actually doesn't seem to make a difference Link to comment https://forums.phpfreaks.com/topic/69858-solved-form-post/#findComment-350932 Share on other sites More sharing options...
JJohnsenDK Posted September 19, 2007 Share Posted September 19, 2007 and the data is save into the database? Link to comment https://forums.phpfreaks.com/topic/69858-solved-form-post/#findComment-350941 Share on other sites More sharing options...
DarkPrince2005 Posted September 19, 2007 Author Share Posted September 19, 2007 Yes,all the data is in the database Link to comment https://forums.phpfreaks.com/topic/69858-solved-form-post/#findComment-350948 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.