Entweder ich bekomme es so hin:
Anzeige 1
-------------------------------
| Link 1 | Link 1 | Link 1 |
-------------------------------
| Link 2 | Link 2 | Link 2 |
-------------------------------
| Link 3 | Link 3 | Link 3 |
-------------------------------
| Link 4 | Link 4 | Link 4 |
-------------------------------
| Link 5 | Link 5 | Link 5 |
-------------------------------
| Link 6 | Link 6 | Link 6 |
-------------------------------
| Link 7 | Link 7 | Link 7 |
-------------------------------
oder:
Anzeige 2
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
aber nicht so:
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
| Link 4 | Link 5 | Link 6 |
-------------------------------
| Link 7 | Link 8 | Link 9 |
-------------------------------
| Link10| Link11| Link12|
-------------------------------
| Link13| Link14| Link15|
-------------------------------
| Link16| Link17| Link18|
-------------------------------
| Link19| Link20| Link21|
-------------------------------
Hier der Code:
Anzeige 1
-------------------------------
| Link 1 | Link 1 | Link 1 |
-------------------------------
| Link 2 | Link 2 | Link 2 |
-------------------------------
| Link 3 | Link 3 | Link 3 |
-------------------------------
| Link 4 | Link 4 | Link 4 |
-------------------------------
| Link 5 | Link 5 | Link 5 |
-------------------------------
| Link 6 | Link 6 | Link 6 |
-------------------------------
| Link 7 | Link 7 | Link 7 |
-------------------------------
oder:
Anzeige 2
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
aber nicht so:
-------------------------------
| Link 1 | Link 2 | Link 3 |
-------------------------------
| Link 4 | Link 5 | Link 6 |
-------------------------------
| Link 7 | Link 8 | Link 9 |
-------------------------------
| Link10| Link11| Link12|
-------------------------------
| Link13| Link14| Link15|
-------------------------------
| Link16| Link17| Link18|
-------------------------------
| Link19| Link20| Link21|
-------------------------------
Hier der Code:
PHP-Code:
$_sel = mysql_query("SELECT * FROM links");
$i=0;
while($y = mysql_fetch_row($_sel))
$x[$i++] = $y[0];
// wieviel haben wir denn ?
$count = count($x);
// es sollen 3 Spalten werden
$spalten = 3;
// macht so viel Zeilen
$zeilen = ($count % $spalten)?(($count -($count % $spalten))/ $spalten +1):$count / $spalten;
// Tabelle zeilenweise ausgeben
echo "<table border=\"1\">\n";
// Zeile für Zeile
for( $i = 0;$i < $zeilen; ++$i )
{
echo "\t<tr align=\"center\">\n";
// Spalte für Spalte
for( $ii = 0;$ii < $spalten; ++$ii )
{
$res1 = mysql_query("SELECT * FROM links LIMIT $i,1");// so gibt er mir Anzeige 1 aus
//$res1 = mysql_query("SELECT * FROM links LIMIT $ii,1");// so gibt er mir Anzeige 2 aus
while($row = mysql_fetch_array($res1))
{
// wenns nichts mehr gibt, ein
echo "\t\t<td><a href=\"$row[b_link]".($z= isset($x[$i * $spalten + $ii])?$x[$i * $spalten + $ii]:" ")."\" target=\"_blank\">$row[link]</a></td>\n";
}
}
echo "\t</tr>\n";
}
echo "</table>";
Kommentar