<?php

$host = "localhost";
$user = "statistics";
$pass = "akecbdy6";
$db = "stats";
$table = "testing";
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect");
mysql_select_db($db) or die ("Unable to select database");

$result= "SELECT * FROM $table ORDER BY id;";

$id = array();
$company = array();
$cpa = array();

if ($result && mysql_num_rows($result)) {
	while (($row = mysql_fetch_assoc($result)) !== false) {
		$id[] = $row['id'];
		$company[] = $row['company'];
		$cpa[] = $row['cpa'];
	}
}

echo "<hr />";
echo $id[0];
echo " ";
echo $company[0];
echo " ";
echo $cpa[0];
echo "<br />";
echo $id[1];
echo " ";
echo $company[1];
echo " ";
echo $cpa[1];
echo "<br />";
echo $id[2];
echo " ";
echo $company[2];
echo " ";
echo $cpa[2];
echo "<br />";


?>




ERROR: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/soluan/domains/stats.soluangroup.net/symfony/apps/frontend/modules/startpage/templates/_VariableDB.php on line 17

Notice: Undefined offset: 0 in /home/soluan/domains/stats.soluangroup.net/symfony/apps/frontend/modules/startpage/templates/_VariableDB.php on line 26

Notice: Undefined offset: 0 in /home/soluan/domains/stats.soluangroup.net/symfony/apps/frontend/modules/startpage/templates/_VariableDB.php on line 28

Notice: Undefined offset: 0 in /home/soluan/domains/stats.soluangroup.net/symfony/apps/frontend/modules/startpage/templates/_VariableDB.php on line 30


Notice: Undefined offset: 1 in /home/soluan/domains/stats.soluangroup.net/symfony/apps/frontend/modules/startpage/templates/_VariableDB.php on line 32

Notice: Undefined offset: 1 in /home/soluan/domains/stats.soluangroup.net/symfony/apps/frontend/modules/startpage/templates/_VariableDB.php on line 34

Notice: Undefined offset: 1 in /home/soluan/domains/stats.soluangroup.net/symfony/apps/frontend/modules/startpage/templates/_VariableDB.php on line 36


Notice: Undefined offset: 2 in /home/soluan/domains/stats.soluangroup.net/symfony/apps/frontend/modules/startpage/templates/_VariableDB.php on line 38

Notice: Undefined offset: 2 in /home/soluan/domains/stats.soluangroup.net/symfony/apps/frontend/modules/startpage/templates/_VariableDB.php on line 40

Notice: Undefined offset: 2 in /home/soluan/domains/stats.soluangroup.net/symfony/apps/frontend/modules/startpage/templates/_VariableDB.php on line 42