Repeat Insert

[nalleyp23]

I have a query from a MySQL database that I am wanting to display on a page.

What I want to happen is that the results are in a repeat region and after every record I want to insert that information into a table then go to the next record and repeat.. I have done this inside the repeat region long ago with ASP but I cant get it to work in PHP.

Any ideas?

Thanks for all the help!

[jek]

Not quite sure what you want, but I guess it's something like this:

<?
$username="username";
$password="password";
$database="database";


//--- Connect to db ---//

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");


//--- Send request ---//

$result = mysql_query( "SELECT `test1`, `test2` FROM `table1` ORDER BY `test1` ASC" ) or die("SELECT Error: ".mysql_error());


//--- Show in table ---//

print "<center>";
print "<table width=60% border=0>\n";
while ($row = mysql_fetch_row($result)){ 
print "<tr>\n";
foreach ($row as $field) 
print "<td><font size=2/>$field</font></td>\n";
print "</tr>\n";
}
print "</table>\n";
mysql_close();
?>