Domāju, ka jā. Patestēju - jā. =)
SQL:
CREATE TABLE `data` (
`name` varchar( 255 ) NOT NULL,
`value` varchar( 255 ) NOT NULL,
PRIMARY KEY ( `name` )
);
INSERT INTO `data` ( `name`, `value` )
VALUES ('red', 'sarkans'), ('green', 'zaļš'), ('blue', 'zils');
INSERT INTO `data` ( `name`, `value` )
VALUES ('white', 'balts'), ('black', 'melns');
PHP:
<?php
error_reporting( E_ALL | E_STRICT );
mb_internal_encoding( 'UTF-8' );
header( 'Content-Type: Text/HTML; Charset=UTF-8' );
mysql_connect( 'localhost', 'root', '' ) or exit;
mysql_select_db( 'foo' ) or exit;
$query = mysql_query("
SELECT `name`, `value`
FROM `data`
LIMIT 0, 3
") or exit;
while( $database = mysql_fetch_array( $query ) ) {
echo "{$database['name']} => {$database['value']}" . '<br />';
}
echo '<br /><br />';
$query = mysql_query("
SELECT `name`, `value`
FROM `data`
LIMIT 3, 4
") or exit;
while( $database = mysql_fetch_array( $query ) ) {
echo "{$database['name']} => {$database['value']}" . '<br />';
}
P.S. Izmanto "
"... =P