$link = mysql_connect("website", "username", "password") or die("Could not connect: " . mysql_error()); mysql_select_db("ircstats") or die("Could not select database \"ircstats\""); $dataARRAY = array(); //SELECT * FROM ircstats $sql = "SELECT name, numberOFlines FROM ircstats"; $result = mysql_query($sql) or die("Query failed: " . mysql_error()); if($result) { while($row = mysql_fetch_assoc($result)) { $name=$row["name"]; $lines=$row["numberOFlines"]; //ADD TO ARRAY $dataArray[$name]=$lines; } }