[SQL] pobierz, plaintext 
CREATE TABLE IF NOT EXISTS `cfg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) COLLATE utf8_polish_ci DEFAULT NULL,
  `value` varchar(40) COLLATE utf8_polish_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `test` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
	mysqli_report(MYSQLI_REPORT_ALL);
	error_reporting(E_ALL);
	$sql_host = 'localhost';
	$sql_user = 'user';
	$sql_pass = 'pass';
	$sql_base = 'base';
	echo "TEST\n";
	$sql = mysqli_connect($sql_host, $sql_user, $sql_pass, $sql_base) or die("1")	;
	$query = "SELECT * FROM cfg USE INDEX (test)";
	$result = $sql->query($query);
	echo $result->error;
		while($tmp = $result->fetch_object())	
			echo $tmp->name.' -> '.$tmp->value."\n";
 
?>
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
CREATE TABLE IF NOT EXISTS `cfg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) COLLATE utf8_polish_ci DEFAULT NULL,
  `value` varchar(40) COLLATE utf8_polish_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
)
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
...
$query = "SELECT * FROM cfg";
...
[PHP] pobierz, plaintext