[Resolved] displaying results

Mr_Hoek

okay,

I am fairly new to php so I will try to make sense in what I am asking.

I am formating the results of a mysql query for display. I want to know the value of a certain field before I set up the table so I can include or leave out a certain column. When I try to loop through the results to see if the value is there it will find it but it will not run the loop when I need to display the results. As if it will only allow you to call a result array once.

here is my code -
###

print"<table align='center' width='95%' border='1' cellpadding='5'><tr>";
	print"<td>";
	if ($stateName == "<b>All States</b>"){
		print"<b>State</b></td><td>";
	}


#### here I need to be able to include a second county seat in the
#### header of the table if it has a value other than N/A
####if I include a second while loop to look for that value it is 
####as if it completely ignores the next one and doesn't display
#### any results

print"<b>County FIPS Code</b></td><td><b>County</b></td><td><b>County Seat</b></td><td><b>Seat Zip Code</b></td>";
print"</tr>";

while ($countyMultiResult = mysql_fetch_array($countyResult)) {
$countyFips = $countyMultiResult['county_fips'];
$countyName = $countyMultiResult['county_name'];
$stateFips = $countyMultiResult['state_fips'];
$countySeat1 = $countyMultiResult['county_seat1'];
$countySeatZip1 = $countyMultiResult['county_seat_zip1'];
$countySeat2 = $countyMultiResult['county_seat2'];
$countySeatZip2 = $countyMultiResult['county_seat_zip2'];
$countyStart = $countyMultiResult['county_start'];
$countyEnd = $countyMultiResult['county_end'];
$countyLink = $countyMultiResult['county_link'];
$countyPhone = $countyMultiResult['county_phone'];
$resultStateName = stateQuery($stateFips , $conn);
print"<tr><td>";
if ($stateName == "<b>All States</b>"){
	print"$resultStateName</td><td>";
}
print"$countyFips</td><td>$countyName</td><td>$countySeat1</td><td>$countySeatZip1</td>";
if ($countySeat2 != "N/A"){
	print"<td>$countySeat2</td>";
}
print"</tr>";

}	print"</table>";

any suggestions would be greatly appreciated
Mr Hoek

jimson

while ($countyMultiResult = mysql_fetch_array($countyResult)) {
extract($countyMultiResult);
// so u will have $county_fips, $county_name
// no need to assign each individually.
}

anyway...
if ($stateName == "All States"){

u didn't show where $stateName from.

jimson

i think

if ($stateName == "All States"){

should be changed to probably

if($resultStateName == "All States") {}

Mr_Hoek

$stateName is a $_post from a search page and I need it to determine something diff from $resultStateName.

I tried your code and it loops through the first while but doesn't process the second loop. here is the updated code.

####

print"<table align='center' width='95%' border='1' cellpadding='5'><tr>";
	print"<td>";
	if ($stateName == "<b>All States</b>"){
		print"<b>State</b></td><td>";
	}

print"<b>County FIPS Code</b></td><td><b>County</b></td><td><b>County Seat</b></td><td><b>Seat Zip Code</b></td>";
while($testResult = mysql_fetch_array($countyResult)){
	extract($testResult);
	if ($county_seat2 != "N/A"){
		$secondSeat = true;
	}
}
if (isset($secondSeat)){
	Print "$secondSeat<br>";
}


###it prints 1 here which is correct
###but it prints nothing past this point even though without the while statement above
### the result set is 20+ rows and displays correctly


print"</tr>";

while ($countyMultiResult = mysql_fetch_array($countyResult)) {
$countyFips = $countyMultiResult['county_fips'];
$countyName = $countyMultiResult['county_name'];
$stateFips = $countyMultiResult['state_fips'];
$countySeat1 = $countyMultiResult['county_seat1'];
$countySeatZip1 = $countyMultiResult['county_seat_zip1'];
$countySeat2 = $countyMultiResult['county_seat2'];
$countySeatZip2 = $countyMultiResult['county_seat_zip2'];
$countyStart = $countyMultiResult['county_start'];
$countyEnd = $countyMultiResult['county_end'];
$countyLink = $countyMultiResult['county_link'];
$countyPhone = $countyMultiResult['county_phone'];
$resultStateName = stateQuery($stateFips , $conn);
print"<tr><td>";
if ($stateName == "<b>All States</b>"){
	print"$resultStateName</td><td>";
}
print"$countyFips</td><td>$countyName</td><td>$countySeat1</td><td>$countySeatZip1</td>";
if ($countySeat2 != "N/A"){
	print"<td>$countySeat2</td>";
}
print"</tr>";

}	print"</table>";

I see your point on the extract(). Its alot cleaner and I will code it that way in the future but it doesn't seem to fix the problem.

thanks for the quick response.

Mr Hoek

Mr_Hoek

here are links to both setups

do a search for clay leave the state select on all states. this will bring a result set of 20+ counties the first one has 2 county seats. what I want to be able to do is display a column for the second county seat only if one of the counties in the result set has one. If not I want it to leave that column off completely.

This one is without the first while loop and it displays the results

not posted anymore

this one includes the first while loop and it wont display the results

not posted anymore

leatherback

Hi,

That is because the $countyResult is empty at that point. You will have to query again OR you have to include the second section in your first "while"loop:

while($testResult = mysql_fetch_array($countyResult))
 { 
  extract($testResult); 
  if ($county_seat2 != "N/A")
  { 
  $secondSeat = true;  

  Print "$secondSeat<br>";  

 } 


###it prints 1 here which is correct 
###but it prints nothing past this point even though without the while statement above 
### the result set is 20+ rows and displays correctly 


print"</tr>"; 

while ($countyMultiResult = mysql_fetch_array($countyResult)) { 
$countyFips = $county_fips;
// etcetc 

$resultStateName = stateQuery($stateFips , $conn); 

print"<tr><td>"; 
if ($stateName == "<b>All States</b>"){ 
print"$resultStateName</td><td>"; 
} 
print"$countyFips</td><td>$countyName</td><td>$countySeat1</td><td>$countySeatZip1</td>"; 
if ($countySeat2 != "N/A"){ 
print"<td>$countySeat2</td>"; 
} 
print"</tr>"; 

} print"</table>";

Something along these lines.

Mr_Hoek

Is there a way to assign the array to another array and use one to set up the table header and the other to loop the results?

If there is no way to pull results from the query more than once that seems silly. or maybe this is just a silly question.. I will try to rerun the query and see if that works. I don't see away to put the second while statement in the first because I am only looking for a single value in the first and not really using it.

one more dumb question while I am showing my ignorance.... Why is $counyResult empty at that point?

leatherback

Hi,

This is what I have done for a situation where I change the layout of display depending on the output:

function extractsamples($condition)
  {
  $condition = $condition;
  $i=0;
  $query = "select * from users where $condition";
  $fileslist = mysql_query($query);

  while($filesrow = mysql_fetch_array($fileslist))
    {
    $files[0][$i] = $filesrow[sa_name];
    $files[1][$i] = $filesrow[us_disp_name];
    $files[2][$i] = $filesrow[sa_copyright];
    $i++;
    }    

  return $files;
  }

This get the results from a database through a defined query. The results are then stored in one big array (files), and the qrray is returned to the main program. You'd call it using:

$data = extractsamples($thiscondition);

Mr_Hoek

I figured it out!!!!

thanks for the help though....

I loaded an Array with the results...

$rows = mysql_num_rows($countyResult);
	$result = array();
	$counter = 0;
	While ($row = mysql_fetch_array($countyResult)){
		$result[$counter] = $row;
		$counter++;
	}

now $result is a multi dimensional Array containing my query results...I can loop through this array as many times as I want without it emptying.....

sooo I loop through to look at a particular field in order to set up my table header...

	$counter = 0;
	$countySeat2Exists = 0;
	while (($counter < $rows) && ($countySeat2Exists == 0)){
		$countySeat2 = $result[$counter]['county_seat2'];
		if ($countySeat2 == "N/A"){
			$countySeat2Exists = 0;
		}else{
			$countySeat2Exists = 1;
		}
		$counter++;
	}
	print"<table align='center' width='95%' border='1' cellpadding='5'><tr>";
	print"<td>";
	if ($stateName == "<b>All States</b>"){
		print"<b>State</b></td><td>";
	}
	print"<b>County</b></td><td><b>FIPS Code</b></td><td><b>County Seat</b></td><td><b>ZipCode</b></td>";
	if ($countySeat2Exists == 1){
		print "<td><b>2nd Seat</b></td>";
	}
	print"</tr>";

then I loop through again to display the table....

	$counter = 0;
	while ($counter < $rows){
	$countyFips = $result[$counter]['county_fips'];
	$countyName = $result[$counter]['county_name'];
	$stateFips = $result[$counter]['state_fips'];
	$countySeat1 = $result[$counter]['county_seat1'];
	$countySeatZip1 = $result[$counter]['county_seat_zip1'];
	$countySeat2 = $result[$counter]['county_seat2'];
	$countySeatZip2 = $result[$counter]['county_seat_zip2'];
	$countyStart = $result[$counter]['county_start'];
	$countyEnd = $result[$counter]['county_end'];
	$countyLink = $result[$counter]['county_link'];
	$countyPhone = $result[$counter]['county_phone'];
	$resultStateName = stateQuery($stateFips , $conn);
	print"<tr><td>";
	if ($stateName == "<b>All States</b>"){
		print"$resultStateName</td><td>";
	}
	print"$countyName</td><td>$countyFips</td><td>$countySeat1</td><td>$countySeatZip1</td>";
	if ($countySeat2Exists == 1){
		if ($countySeat2 == "N/A"){
			print"<td>&nbsp;</td>";
		} Else {
		print"<td>$countySeat2</td>";
	}}
	print"</tr>";
	$counter++;
}	print"</table>";

You know a good array tutorial that explains how to move data from one array to another and how to get info out and such would be really nice. I found that the documentation is either real basic stuff you will move past quickly or incredibly complex expecting you to know very advanced concepts and syntax.

Thanks for the help... I am sure I will need more as the projects get bigger