Dear all I was trying to fetch all the data from one of my table "leaverequest", but i couldn't fetch all the data if i use the * . here is my program, this one is only fetch the Reason field, but what i want is all the data. <? $dblink=mysql_pconnect("microsoft","console","edshk"); mysql_select_db("nedcorhk",$dblink); $query = "select * from leaverequest"; $result=mysql_query($query,$dblink); while ($row= mysql_fetch_array($result,MYSQL_ASSOC)) { print ("{$row["Reason"]}"); } ?> But can i do it like that way to get all the data? (Showing below) : <? $dblink=mysql_pconnect("microsoft","console","edshk"); mysql_select_db("nedcorhk",$dblink); $query = "select * from leaverequest"; $result=mysql_query($query,$dblink); while ($row= mysql_fetch_array($result,MYSQL_ASSOC)) { print ("{$row["*"]}"); } ?> Pls help me!! Thx jack [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]