Displaying MYSQL query results.

[Arc]

I am using this code to make a query and store it in an array.

$Sql= "SELECT * FROM CreditApp WHERE caDate LIKE '$Date%'";
$Result = mysql_query($Sql, $Connect_PaulMiller);
$ResultArray=@mysql_fetch_array($Result);

I would like to take the rows i retrieve from this query and display them the way databases are normally displayed...with field name on top then row info in collums below the field names.

I have already created the field names rows and i wish to dynamically create other rows and collums forming a table with all the info from the Result Query. Example

print "<table border = \"1\" cellspacing=\"0\" cellpadding=\"2\" BorderColor = \"#000000\">";
print "<tr><th>ID</th><th>First Name</th><th>Middle Name</th><th>Last Name</th><th>D.O.B.</th><th>Zip</th><th>Address</th><th>City</th><th>State</th><th>S.S.N.</th><th>Home Phone
</th><th>Email</th><th>TAR</th><th>Employer</th><th>Employer Phone</th><th>Job Title</th><th>L.O.E.</th><th>Anual Income</th></tr>";


//Then have it Print the the query results below each field name and also create its own row/collum as it goes
//No idea how to do this.

While ($ResultArray =?){
Print "<td><th>Field Value </td></th>";
}

That is totaly wrong...but i hope it gives the idea of what i need.

Thanks ALot!😃

[matto]

like this:

while($ResultArray=@mysql_fetch_array($Result)) // for each record ...
{
echo "<tr>";

for($i=0; $i<count($Result); $i++) // loop through the fields of each record
{
echo "<td>".$Result[$i]."</td>";
}

echo "</tr>\n";
}