cancer10

HI Guys, hellreaper's code worked like a charm. But If you try to read a file with formulaes for example if you add the formula =SUM(B1,B2,C1,D2) somewhere in the file, then the new generated file will be generated with reversed GUI. PFA excel file for example. Does anyone have any idea how to fix this? [attachment deleted by admin]

Now that is a quick and effective reply Thanx a ton mate you solved my problem 2 Quick questiona - 1) does using mysql_fetch_array() will take more resource compared to mysql_fetch_row()? 2) Is this the only difference between mysql_fetch_array() and mysql_fetch_row()? Thanx again

ok, see the code below <? $rsQry = mysql_query ("select * from tblCustomer"); $arrQry = mysql_fetch_row($rsQry); ?> Now if I try to fetch a Customer's Name from the "Customer_Name" column from the "tblCustomer" table with the following code then I dont get anything: <? echo $arrQry["Customer_Name"]; ?> Why? PS: I have tried this way and it works: <? echo $arrQry[0]; ?> But I want to use the column name instead of the column number. Any idea? Thanx