php从mysql提取数据_PHP从MySQL提取数据

我有这个与以下行的MySQL表：

id_cont suma_lun month year

--------------------------------------------

FL28 2133 March 2012

FL28 2144 April 2012

FL28 2155 May 2012

FL28 2166 June 2012我如何提取suma_lun，月份和年份foreach id_cont？所以我得到这样的输出：

ID: Month: Monthly Sum: Year:

----------------------------------------------

FL28 March 2133 2012

April 2144 2012

May 2155 2012

June 2166 2012这是我现在的代码：

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

if(!$link) die ('Could not connect to database: '.mysql_error());

mysql_select_db(DB_DATABASE,$link);

$sql="SELECT * FROM test WHERE id_cont = '$cur'";

$result=mysql_query($sql);

while ($row=mysql_fetch_array($result)) {

$a=$row["id_cont"];

$b=$row["suma_lun"];

$c=$row["month"];

$d=$row["year"];

}我在表中回显数据

谢谢！