Kód: Vybrať všetko

<?php
$link = mysql_connect("localhost", "user", "password")
or die("Could not connect");
//print "Connected successfully";
mysql_select_db("aaa") or die("Couldn't select db");
$query = "SELECT * FROM band";
 $result = mysql_query($query) or die("Query failed");  
 
 		
 
 echo '<br><table border="1" align="center" >';
echo'<tr><td>ID</td><td>Datum</td><td>Mesto</td><td>Miesto</td></tr>';


while($line=mysql_fetch_array($result,MYSQL_ASSOC)) {
echo"<tr>";	

foreach($line as $col_value) {
echo "\t\t<td>$col_value</td>\n";
}
echo"</tr>\n";
}
echo "</table>\n";
mysql_free_result($result);
mysql_close($link);
?>

Kód: Vybrať všetko

foreach($line as $col_value) {
echo "\t\t<td>$col_value['datum']</td><td>$col_value['mesto']</td><td>$col_value['miesto']</td>\n";
}

Kód: Vybrať všetko

bTest = 0;
foreach($line as $col_value) {
if (bTest != 0 )
echo "\t\t<td>$col_value</td>\n";
bTest++;
}

Kód: Vybrať všetko

echo "\t\t<td>$line['datum']</td><td>$line['mesto']</td><td>$line['miesto']</td>\n";