<? mysql_connect ('localhost', 'username', 'password') ; mysql_select_db ('database_name_here'); $num_displayed = 6 ; $result = mysql_query ("SELECT * FROM links ORDER BY RAND() LIMIT $num_displayed"); while ($row = mysql_fetch_array($result)) { echo "<a href=\"" . $row["link"] . "\">" . $row["text"] . "</a><br>" ; } ?>
Ten kod wylosuje mi 6 linkow z bazy i wyswietli je tak:
Link 1
Link 2
....
Link 6
Ja mam tabele z 3 kolumnami i chcialbym zeby to wygladalo tak:
Link 1 Link 3 Link 5
Link 2 Link 4 Link 6
Jak to zrobic? Wiem, ze dla kogos kto zna sie na PHP to zaden problem ale ja jestem newbe
