Location: PHPKode > projects > GEStione SOci > gesso-1.0.0/member_query_result.php
<link href="gesso.css" rel="stylesheet" type="text/css">
<table border="0" cellpadding="0" cellspacing="0" class="content"> 
	<tr> 
		<td class="content_top">Lista Soci</td> 
	</tr> 
	<?
$query = "select a.*, date_format(a.registration_date, '" . DATETIME_FORMAT . "') registration_date_f from tmember a";
$query = SQL_SELECT_MEMBER;
$where = "";

if ($p_member_id != "") $where .= "and member_id = $p_member_id";
if ($p_name != "") $where .= "and name regexp '$p_name'";
if ($p_surname != "") $where .= "and surname regexp '$p_surname'";
if ($p_member_type_id != "") $where .= "and a.member_type_id = '$p_member_type_id'";
if ($p_membership_card_number != "") $where .= "and membership_card_number = '$p_membership_card_number'";
if ($p_registration_date != "") $where .= "and date_format(registration_date, '" . DATE_FORMAT . "') = '$p_registration_date'";

$query .= "$where order by member_id";
$result = mysql_query($query)
	or die("Query failed! " . mysql_error());
			?> 
	<tr> 
		<td><br> 
			<table border="0" cellspacing="1" cellpadding="0"> 
				<tr> 
					<td class="list_label"><div align="right">Mat</div></td> 
					<td class="list_label">Nome</td> 
					<td class="list_label">Cognome</td> 
					<td class="list_label">Tipo</td> 
					<td class="list_label"><div align="right">N. Tessera</div></td> 
				   <td class="list_label">Data Registrazione</td>
				</tr> 
				<?
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
	$class_list_value = (($line[flag_unwanted] == "Y") ? ("list_value_unwanted") : ("list_value"));
												?> 
				<tr> 
					<td class="<?= $class_list_value ?>"><div align="right"><a class="list_value" href="index.php?p_action=member_detail&p_member_id=<?= $line[member_id] ?>"> 
							<?= $line[member_id] ?> 
						</a></div></td> 
					<td class="<?= $class_list_value ?>"><?= $line[name] ?></td> 
					<td class="<?= $class_list_value ?>"><?= $line[surname] ?></td> 
					<td class="<?= $class_list_value ?>"><?= $line[member_type_description] ?></td> 
					<td class="<?= $class_list_value ?>"><div align="right"><?= $line[membership_card_number] ?>
					</div></td> 
				   <td class="<?= $class_list_value ?>"><?= $line[registration_date_f] ?></td>
				</tr> 
				<?
}
												?> 
			</table></td> 
	</tr> 
</table> 
Return current item: GEStione SOci