Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

« Newer Snippets
Older Snippets »
Showing 1-2 of 2 total  RSS 

Loop de X elementos por fila

// Genera una estructura que va colocando un resultset en filas de X elementos.

<?php

// Catálogos
$catalogos_query = 'SELECT catalogos.* FROM catalogos WHERE catalogos.estado = 1 ORDER BY catalogos.id_catalogo DESC';
$catalogos_rs = mysql_query( $catalogos_query );
$catalogos_num = mysql_num_rows( $catalogos_rs );

// inicia looper
$elem_count = 0;
$elem_total_count = 0;
$elem_per_row = 6; // Configurar esto!
// bucle entre todas los elementos a mostrar
while( $row = mysql_fetch_assoc( $catalogos_rs ) ) :
	$elem_count++;
	$elem_total_count++;
?>

	<?php if ( $elem_count == 1 ) : // si es el primer elemento de la fila.... ?>

	<div class="catalogoRow">

	<?php endif; ?>	

	<?php if ( $elem_count == $elem_per_row ) : // si es el último elemento de la fila...
		$class = "catalogoContainer ultimo";
	else:
		$class = "catalogoContainer";
	endif; ?>

		<div class="<?php echo $class ?>">

			<div class="catalogoImagen">
				<a target="_blank" href="/arxius/catalogos/<?php echo $row['archivo']; ?>"><img src="../arxius/catalogos/<?php echo $row['imagen']; ?>" alt="<?php echo $row['titulo_'.$idioma]; ?>" border="0" /></a>
			</div>
			<div class="catalogoTitulo">
				<p><?php echo $row['titulo_'.$idioma]; ?></p>
			</div>

		</div><!-- end .container -->

	<?php if ( $elem_count == $elem_per_row || $catalogos_num == $elem_total_count ) : // elem_db_total es el total de reg. a mostrar de la bbdd ?>
		<div class="clear"></div>

	</div><!-- end .row -->

	<?php $elem_count = 0; endif; ?>

<?php endwhile; ?>

RecordSet to tab-separated values

Function TSV(rs)
	Dim field
	For Each field In rs.Fields
		TSV = TSV & field.Name & VBTab
	Next
	TSV = Left(TSV, Len(TSV) - 1) & vbCr & rs.GetString()
End Function


The rows are separated by vbCr ("\r" in most languages).
The first row is the field names.
« Newer Snippets
Older Snippets »
Showing 1-2 of 2 total  RSS