Loop de X elementos por fila

sveggiani (Sebastián) — Wed, 17 Oct 2007 12:46:19 GMT

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





// 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++;

?>



	



	



		



			$class = "catalogoContainer ultimo";

	else:

		$class = "catalogoContainer";

	endif; ?>



		



			

				" alt="" border="0" />

RecordSet to tab-separated values

mrclay (Steve Clay) — Wed, 07 Mar 2007 21:51:49 GMT



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.

DZone Snippets: resultset code

Loop de X elementos por fila

RecordSet to tab-separated values