Andmete vaatamine MySQL tabelist (SELECT)


<?php

//alati peaks alguses olema need read

set_magic_quotes_runtime(0);

setlocale(LC_TIME, 'Estonia', 'et_EE');

error_reporting(E_ALL); 

set_time_limit(30); 



//universaalsete funktsioonide kutsumine

require_once 'abifunktsioonid.php'; 

require_once 'mysql.php'; 



$sql = 'SELECT * FROM neeme_proov';

$res = dbArray($sql); 



//Andmed tulevad nüüd foreach-iga

if($res) 

echo '<TABLE border="1" width="30%">';

{

    

    foreach ($res as $key=>$row)

        {

        echo '<TR>';

        echo '<TD>'.fixHtml($row['nimi']).'</TD>'; 

        echo '<TD>'.fixHtml($row['aasta']).'</TD>';

        echo '<TD>'.fixHtml($row['kaal']).'</TD>';

        echo '</TR>';

        }

echo '</TABLE>';

}

?>