database content

[weazy]

I am trying to return the entire contents of a database w/o having to identify each variable. I am using an ODBC connection and querying like so:

$sql = "SELECT * FROM History";
$result = odbc_exec($conn, $sql);

thanks.

[jignesh1]

im not sure abt this one but i use mysql so i use while looping and mysql_fetch_array function to display all the content from the table
i dont know watch function to use for odbc

[laserlight]

Entire contents of a database, or of a table?

[leatherback]

this is part of a generic database-dump script I wrote, will show all fields in all records of a database table, ready for re-insert. You'll getthe idea, I suppode:

$table_query = mysql_query("SELECT * FROM $table");
$num_fields = mysql_num_fields($table_query);
while ($fetch_row = mysql_fetch_array($table_query))
{
$insert_sql .= "INSERT INTO $table VALUES(";
for ($n=1;$n<=$num_fields;$n++)
{
$m = $n - 1;
$insert_sql .= "'".mysql_escape_string($fetch_row[$m])."', ";
}

$insert_sql = substr($insert_sql,0,-2);
$insert_sql .= ");\n";
}