mysql_connect("127.0.0.1","root","") or die (mysql_error());
$projectids=Array();
$projectn=Array();
$sql="SELECT * FROM eseamembers.projects WHERE (hidden=0) AND (official=1)";
$counter=1;
$status=mysql_query($sql) or die (mysql_error());
while ($row = mysql_fetch_array($status)){
$projectn[$counter]=$row['project'];
$projectids[$counter]=$row['id'];
$counter++;
//echo $counter." project: ".$row['id']." ";
}
mysql_close() or die (mysql_error());
?>