Code: Select all
function getMembersPhoto(){
Global $connection;
$today = date("Ymd");
$member = $_GETї'MID'];
$numcols = 3; // how many columns to display
$numcolsprinted = 0; // no of columns so far
hookUpDb();
$query = "SELECT t1.*, t3.MemberNum
FROM photos t1, xrefphotomember t2, memberinfo t3
WHERE t3.MID = $member";
$result = mysql_query($query,$connection);
openPhotoTable();
while ($row = mysql_fetch_row($result)){
$PID = $rowї0];
$PhotoNum = unFormatData($rowї1]);
$PhotoDescr = unFormatData($rowї2]);
$MemberNum = unFormatData($rowї4]);
$PhotoURL = "images/cars/". $MemberNum. "-". $PhotoNum. ".jpg";
$Thumb = "images/cars/". $MemberNum. "-". $PhotoNum. "-thumb.jpg";
$OnClick = "onClick="JustSoPicWindow('". $PhotoURL. "','600','451','* * Click screen to close * *','#000000','hug image','0');return document.MM_returnValue"><img src="$Thumb" alt="" width="169" height="127" border="0"></a><br />$PhotoDescr</td>";
$Output = "<td class="memberdata"><a href="javascript:;" ". $OnClick;
if ($numcolsprinted == $numcols) {
print "</tr>\n<tr>\n";
$numcolsprinted = 0;
}
print("$Output");
$numcolsprinted++;
}//end while
$colstobalance = $numcols - $numcolsprinted;
for ($i=1; $i<=$colstobalance; $i++) {
print "<TD class="memberdata"></TD>\n";
}
closePhotoTable();
closeMemberTable();
mysql_free_result($result);
mysql_close($connection);
}