[RESOLVED] Can't get a foreach loop to process all records

WadeG

Hi there, I'm trying to build a page based on some user selections. Things seem to be work properly but I can't get it to loop through more then the first record...

Here's the Code:

<?php
include 'config.php';
include 'opendb.php';
date_default_timezone_set("America/Edmonton");
require_once('PDF_Label.php');

$pdf = new PDF_Label('5160', 'mm', 1, 2);
$pdf->Open();
$pdf->AddPage();

$action=$_GET['action'];
switch ($action) {
case "Cal":
   $searchStr = "xCalendar";
	 break;
case "iGift":
   $searchStr = "xIndivGift";
	 	 break;
case "GShirt":
   $searchStr = "gShirt";
	 	 break;
case "GBalls":
   $searchStr = "gBalls";
	 	 break;
case "SShirt":
   $searchStr = "sShirt";
	 	 break;
case "BLI":
   $searchStr = "xBuilderLunchInvite";
	 	 break;
case "DJD":
   $searchStr = "DJDInvite";
	 	 break;
case "SAM":
   $searchStr = "SAM";
	 	 break;
default :
	 $searchStr = "0";				
}

$query = mysql_escape_string("SELECT ContactID FROM anualevents WHERE " . $searchStr . "=1");
$result = mysql_query ($query)or die ('I cannot connect to the database because: ' . mysql_error());
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$total = mysql_num_rows($result);
echo ("Total records: " . $total . "<br>");

foreach($row as $i => $v){
var_dump($row);
    $query1 = mysql_escape_string("SELECT * FROM _contact WHERE ContactID = " . $row[$i]['ContactID'] );
    $result1 = mysql_query ($query1)or die ('I cannot connect to the database because: ' . mysql_error());
    $row1 = mysql_fetch_array($result1, MYSQL_ASSOC);
   echo("<br><br>" . $query1);
	 if(!$row1['Prefix']){
    	       $fullName = $row1['FirstName'] . " " . $row1['LastName'];
	}else{
		  $fullName = $row1['Prefix'] . " " . $row1['FirstName'] . " " . $row1['LastName'];
	}
    $address = $row1['City'] . " " . $row1['Province']. " " . $row1['Postal'];
    echo("<br>Fullname: " . $fullName . "<br>Address: ". $row1['StreetAddress'] . "<br>" . $address);

//Print labels
//$pdf->Add_PDF_Label(sprintf("%s\n%s\n%s", $fullName, $row1['StreetAddress'], $address));
  //$pdf->Output();
}
include 'closedb.php';
?>

Hoping a fresh set of eyes can help me out.

Thanks!

NogDog

mysql_fetch_array() only returns one result row from the query. The most common idiom for looping through all the results is:

while($row = mysql_fetch_array($result))
{
   // do whatever needs doing for this result row
}

WadeG

NogDog wrote:
mysql_fetch_array() only returns one result row from the query. The most common idiom for looping through all the results is:
while($row = mysql_fetch_array($result))
{
   // do whatever needs doing for this result row
}

Thanks for the quick response!

I think I got it now...

$query = mysql_escape_string("SELECT ContactID FROM anualevents WHERE " . $searchStr . "=1");
$result = mysql_query ($query)or die ('I cannot connect to the database because: ' . mysql_error());
echo ("Total records: " . $total . "<br>");
while($row = mysql_fetch_array($result)){
var_dump($row);
    $query1 = mysql_escape_string("SELECT * FROM _contact WHERE ContactID = " . $row['ContactID'] );
    $result1 = mysql_query ($query1)or die ('I cannot connect to the database because: ' . mysql_error());
    $row1 = mysql_fetch_array($result1, MYSQL_ASSOC);
   echo("<br><br>" . $query1);
	 if(!$row1['Prefix']){
    	$fullName = $row1['FirstName'] . " " . $row1['LastName'];
		}else{
		  $fullName = 		$row1['Prefix'] . " " . $row1['FirstName'] . " " . $row1['LastName'];
		}
    $address = $row1['City'] . " " . $row1['Province']. " " . $row1['Postal'];
    echo("<br>Fullname: " . $fullName . "<br>Address: ". $row1['StreetAddress'] . "<br>" . $address);

	//Print labels
	//$pdf->Add_PDF_Label(sprintf("%s\n%s\n%s", $fullName, $row1['StreetAddress'], $address));
  //$pdf->Output();
}
include 'closedb.php';

Thanks again!!

NogDog

No problem. If that solves your problem, be sure to click the "Thread Tools" link at the top of the thread and mark it resolved. 🙂