help regarding file read

greedyisg00d

I have a table Employee with 4 columns namely Name, Address, Contact No. and Owner. The data is tabulated in ms excel and then converted into text. What I want is to get and echo the value of the column Name only assuming that I have more than 1000 of records. Any idea on how can this be done? Sample code is much appreciated. Thanks

scspl_dilip

Hi,

Please explain in more that would you like to display column name only? or you want to display data only?

Please describe in detail with output format like :

|Column1 head | Column2 Head

|Data 1 | Data2

dilip

greedyisg00d

I want to retrieve all data of a specific column which goes like this

NAME
Microsoft
HP
Mac
Linux

Thus I will get and echo the data above

scspl_dilip

hi,

try below code, it will return all the fields with all the data

mysql_connect("localhost","database_username","database_password");
mysql_select_db("database_name");

$query=mysql_query("select * from admin");
$rows=mysql_fetch_array($query);
$columns = array_keys($rows);

//======= Below will return table column names
foreach($columns as $key=>$val)
{
echo "$key=>$val<br>";
}
while($data_rows=mysql_fetch_array($query))
{
foreach($columns as $key=>$val)
{
//==== This will print all the data and here you can put
//condition if you would like to discard any columns
echo $data_rows[$val]."<br>";
}
}

anoopmail

file_get_contents