$link = mysql_connect($host, $user, $pass);
if(!$link){
echo 'Błąd połączenia z bazą';die;
}
mysql_select_db($db_name);
mysql_query("SET NAMES utf8");
$query = 'select currencies.name, rates.date, rates.rate from currencies, rates where rates.currency_id = currencies.id';
$result = mysql_query($query);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<table>
<tr>
<td>Pole 1</td>
<td>Pole 2</td>
<td>Pole 3</td>
</tr>
<?php
{
echo '<td>'.$row['name'].'</td>'; echo '<td>'.$row['date'].'</td>'; echo '<td>'.$row['rate'].'</td>'; }
?>
</table>
</body>
</html>
a tabele wyglądają tak:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
CREATE TABLE IF NOT EXISTS `currencies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` char(3) NOT NULL,
`name` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
INSERT INTO `currencies` (`id`, `code`, `name`) VALUES
(1, 'USD', 'United States dollar'),
(2, 'JPY', 'Japanese yen'),
(3, 'GBP', 'Pound sterling'),
(4, 'PLN', 'Polish zloty'),
(5, 'CAD', 'Canadian dollar');
CREATE TABLE IF NOT EXISTS `rates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`currency_id` int(11) NOT NULL,
`date` date NOT NULL,
`rate` decimal(8,5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
INSERT INTO `rates` (`id`, `currency_id`, `date`, `rate`) VALUES
(1, 1, '2010-02-02', '1.32601'),
(2, 2, '2010-02-02', '119.27520'),
(3, 3, '2010-02-02', '0.88664'),
(4, 4, '2010-02-02', '4.00257'),
(5, 5, '2010-02-02', '1.58608'),
(6, 1, '2010-02-03', '1.33940'),
(7, 2, '2010-02-03', '120.48000'),
(8, 3, '2010-02-03', '0.89560'),
(9, 4, '2010-02-03', '4.04300'),
(10, 5, '2010-02-03', '1.60210'),
(11, 1, '2010-04-08', '1.32960'),
(12, 2, '2010-04-08', '123.76000'),
(13, 3, '2010-04-08', '0.87500'),
(14, 4, '2010-04-08', '3.84980'),
(15, 5, '2010-04-08', '1.34070');