[RESOLVED] write file to server using html and table outputed from select statement

OwenTheSamoan

I have a table that outputs photos that are three rows of five. This table basically stays the same all the time and I would like to have it so that it can be called up without having every member using a select statement to the database. What I would like to do is copy the HTML output of the table with it's contents saved as a file on my server and have this file called up instead of having to use the select statement to the database everytime. The select statement is a bit complex, this is why I want to avoid trying to use it. My problem is that I can't seem to save the HTML output to a file. I get errors if I try to save the output as a string or variable to place in a file.

$myFile = "folder/".filename.".txt";
$fh = fopen($myFile, 'w') or die("can't open file");
$stringData = "$HTML_table_string\n";
fwrite($fh, $stringData);
fclose($fh);

Here is the coding I am using to output my table without the select statement.

$sql = select statement here.....
while ($img_info = mysql_fetch_array($sql)){

$LSusername= $img_info["username"];

echo '<td valign=bottom align=center>';

// generate the image tag
echo '<a href=something.php?something='.$LSusername.'>';
$SubDirect = strtolower($LSusername); // make lowercase
$Direct = $SubDirect{0}; // take first letter
echo '<img src="./xxxx/'.$Direct.'/'.$SubDirect.'/'. $img_info["img_file"] . '.jpg" alt="click on photo" style="width: 100px; height: 100px; border: 0px;" />';
echo '<br />';
echo $LSusername;
echo '</a>';
echo '</td>';

$loop_pos++;

if ($loop_pos >= 5)
{
echo '</tr><tr>';
$loop_pos = 0;
}
}// end while loop;

// free result from SQL Memory;
mysql_free_result($sql);

echo '</tr>';

OwenTheSamoan

$text = '<tr>';

unset($loop_pos);
$loop_pos = 0;

$sql =mysql_query("SELECT statement);

while ($img_info = mysql_fetch_array($sql)){

$LSusername = $img_info["username"];

$text .= '<td valign=bottom align=center>';

$text .= '<a href=something.php?something ='.$LSusername.'>';

$SubDirect = strtolower($LSusername);
$Direct = $SubDirect{0}; // take first letter

$text .= '<img src="./xxxxx/'.$Direct.'/'.$SubDirect.'/'. $img_info["img_file"] . '.jpg" alt="click on photo" style="width: 100px; height: 100px; border: 0px;" /><br />';

$text .= "$LSusername";
$text .= '</a>';
$text .= '</td>';

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

$loop_pos++;

if ($loop_pos >= 5)
{
$text .= '</tr><tr>';
$loop_pos = 0;
}
}// end while loop;

// free result from SQL Memory;
mysql_free_result($sql);

// unset variables to clean memory;
unset($img_info);
unset($sql);
unset($loop_pos);

$text .= '</tr>';