Question about my array...

[RynMan]

Hi guys

 

I'm struggling a little with the concept arrays, not sure why this doesn't work. 

 

I have this code:

 

$result9 = mysql_query("SELECT * FROM `tblclientinformation` LEFT JOIN tblphotos ON tblclientinformation.KAMClientID = tblphotos.KAMClientID WHERE Current = 1 AND Gender='$Gender' AND Actor=TRUE $LocationQ ORDER BY LastName LIMIT $RecordNumber, $RecordsOnPage", $connection);
if (!$result9) { 
die("Database query failed" . mysql_error()) ;
}

 

Then later on down the page I want to use it like this....

 

while ($row9 = mysql_fetch_array($result9)) {

	echo '<td width="125" align="center"><a class="actorsListLink" href="cvprofile.php?ID='.$row9["KAMClientID"].'"><img src="headshot/ListHeadShot/'.$ListHeadShot.'" border="0" width="72" height="90" /><br />'.$row9["FirstName"]."<br />".$row9["LastName"].'<br />'.$row9["KAMClientID"].'</a></td>';
	}

 

Everything echos here except "KAMClientID".  The first and last names work fine, but the ID does not.  I've done a print_r for my array and it is in there as the first item in the array [0].  When I substitute the "KAMClientID" for zero, it works perfectly.  Why do my other accept the text, however this one does not?

[TeddyKiller]

Why do my other accept the text

 

Aren't ID's best as int(11) either auto-increment if its the id of the row, or not auto-increment for else?

I can't really see the problem, have you tried taking away the capital letters?