I cannot figure out why everything is not displaying

[aeroswat]

Nevermind got another problem... now it's only showing the first three... there should be about 600 results popping up and they did before i put the divs in there

Not sure if its the php or the css... any advice?

 

.containerorder{
position: relative;
overflow: hidden;
margin: 0px auto;
height: 11in;
width: 8.5in;
}
.outorder{
position: relative;
overflow: hidden;
margin: 0px auto;
height: 34%;
width: 100%;
}
.toporder{
position: relative;
overflow: hidden;
margin: 0px auto;
height: 7%;
width: 100%;
}
.midorder{
position: relative;
overflow: hidden;
margin: 0px auto;
height: 40%;
width: 100%;
font-weight: bold;
}
.mainorder{
position: relative;
overflow: hidden;
margin: 0px auto;
height: 33%;
width: 100%;
}
.bottomorder{
position: relative;
overflow: hidden;
margin: 0px auto;
height: 20%;
width: 100%;
font-weight: bold;
font-style: italic;
}
.div1order{
position: relative;
overflow: hidden;
float: left;
width: 60%;
font-weight: bold;
}	
.div2order{
position: relative;
overflow: hidden;
float: right;
width: 40%;
font-weight: bolder;
}
.div3order{
position: relative;
overflow: hidden;
float: left;
width: 50%;
background-color: #f4f4f4
}	
.div4order{
position: relative;
overflow: hidden;
float: right;
width: 50%;
font-weight: normal;
background-color: #e6e6e6
}	

 

<?php

require_once('auth.php');
require_once('config.php');

function addspace($str, $len){
	if (strlen($str) >= $len){return $str;}

	return $str . str_repeat(' ', $len-strlen($str));
}

$link = mysql_connect(DB_HOST, DBA_USER, DB_PASSWORD);
if(!$link) {
	die('Failed to connect to server: ' . mysql_error());
}

$db = mysql_select_db(DBA_DATABASE);

if(!$db) {
	echo DBA_DATABASE;
	die("Unable to select database");
}

$qry = "SELECT * FROM tblOrders WHERE filled=0";
$result = mysql_query($qry);

if($result) {
	if(mysql_num_rows($result)!=0) {
		echo "<link href=\"loginmodule.css\" rel=\"stylesheet\" type=\"text/css\" />";
		echo "<div class='containerorder'>";
		while($res=mysql_fetch_array($result)) {
			$qryCode = "SELECT * FROM tblCodes WHERE Code='" . $res['Code'] . "'";
			$resultCode = mysql_query($qryCode);
			$resCode = mysql_fetch_array($resultCode);
			$qry2 = "SELECT StudentName FROM tblStudents WHERE StudentNumber=" . $res['StudentNumber'];
			$result2 = mysql_query($qry2);
			$res2 = mysql_fetch_array($result2);
			echo "<div class='containerorder'>";

			for($i=0;$i<3;$i++){
				echo "<div class='outorder'>" .
					"<div class='toporder'>" .
						"<div class='div1order'>" .
							"Alabama Instructional Resource Center for the Blind" .
						"</div>" .
						"<div class='div2order'>" .
							addspace('ORDER ACKNOWLEDGMENT',40) . ($i+1) .
						"</div>" .
					"</div>" .
					"<div class='midorder'>" .
						"<div class='div3order'>" .
							"Alabama Institute for the Deaf and Blind<br>" .
							"P.O. Box 698, Talladega, AL 35161<br>" .
							"1-256-761-3262 or 1-256-761-3337<br><br>" .
							$resCode['Definition'] .
						"</div>" .
						"<div class='div4order'>" .
							"Process Date: " . addspace($res['DateOrdered'],30) . "Ship Date:<br>" .
							"Order Number: Line Number:<br><br>" .
							"Title: " . $res['BookTitle'] . "<br>" .
							"ISBN#: " . $res['ISBNten'] . "<br>" .
							"Publisher: " . $res['Publisher'] . "Copyright: " . $res['Copyright'] . "<br>" .
						"</div>" .
					"</div>" .
					"<div class='mainorder'>" .
						"<div class='div3order'>" .
							"Student:<br>" .
							"Schools<br>" .
							"Address<br>" .
							"City, State Zip<br>" .
						"</div>" .
						"<div class='div4order'>" .
							"AIRCB#:<br>" .
							"Item#: Value:<br>" .
							"Format: Grade: Record Number:<br>" .
							"Upon receipt of item, please sign and return.<br><br>" .
							"Signature _______________________ Date __________<br>" .
						"</div>" .
					"</div>" .
					"<div class='bottomorder'>" .
						"<center>All items MUST be returned to AIRCB ASAP at the completion of each course.</center>" .
					"</div>" .
				"</div>";
			}

			echo "</div>";
		}
	}else {
		echo "There are no results to be displayed";
	}
}else {
	die("Query failed");
}
?>
<?php include("footer-main.php"); ?>

[aeroswat]

Posting again because I changed the status

[mrMarcus]

for($i=0;$i<3;$i++){

 

*note the 3

[aeroswat]

for($i=0;$i<3;$i++){

 

*note the 3

 

That for loop is just so that I have 3 copies of each order acknowledgment displayed on my end. I need to keep one, send one to the person ordering, and send one to the agency that is recording this.

[mrMarcus]

view your source in the browser, if all the records are present but are not visible, then it's a CSS problem .. otherwise, a PHP problem.