get all data from a table whatever the number of columns

[cotede2]

Hello , in PHP , I'd like with only a few lines to get all data from a table without the obligation to specify the number of fields and their names.

 

I got like 200 fields multiply by 12 tables ...

So if the structure is liek that:

FName LName Age

 

 

while($e = mysql_fetch_array($query)){

//code I am looking for

}

 

Displays

 

Fname => dupond

Lname => arthur

Age => 18 ..

thanks.

 

[RussellReal]

you could echo it into a javascript array, and have javascript push the raw data into a table, that will considerably cut down on the loading time.. since its javascript which is a client side language, so you'll be sending the MINIMAL amount of data, and the browser will handle it..

[cotede2]

I dont get it .

what javascript has to do with it?

I could echo what?

[cotede2]

print_r is nice it displays a display with all the data.

Array ( [0] => 548084 [MLSNumber] => 548084 [1] => 184900 [PriceListing] => 184900 [2] => BROADKILL HUNDRED [Area] => BROADKILL HUNDRED [3] => A [statusActual] => A [4] => BETWEEN RT. 1 & 113 [section] => BETWEEN RT. 1 & 113 [5] => DUORY CIRCLE [AddressStreetName] => DUORY CIRCLE [6] => MILTON [AddressCity] => MILTON [7] => [AddressUnitNumber] => [8] =>

[MexiTek]

You could try this inside your while.

 

     

while ( list($key,$value) = each($e) )
      {
          echo $key.' => '.$value;
      }

[MadTechie]

Something like this should do it

 

<?php
$tables = array("table1", "table2","etc");
$data = array();
foreach($tables as $table)
{
echo "$table<br>/n";
$result = mysql_query("SELECT * FROM $table");
echo "<pre>";
while ($row = mysql_fetch_assoc($result))
{
	var_dump($row);
	//$data[$table][] = $row; //Capture data
}
echo "</pre>";
echo "<br>/n";
}

//var_dump($data); //show all data

?>

 

EDIT: added a capture array (commented out)