display images and other data(php/mysql)

spato

hi guys,
I have this code to display my images and other data from my database using php... but the two just wont display.One displays and the other doesn't.I don't know what to do....could someone please help me out?
my e-mail:dickrichus@hotmail.com

and this is the code:

$sql=("select * from binary_data");

$result=mysql_query($sql) or die(mysql_error());

for($i=0;$i<mysql_num_rows($result);$i++)
{
$row=mysql_fetch_array($result);

$tableid=$row['id'];
if($id == $tableid)
{

echo mysql_result($result, 0 ,"bin_data");
<html>
<body>
<table width="100%" hieght="100%" border="2" bordercolor="pink">
<th>
<?php echo "<h2>Item was found</h2> "; ?>
<th>
<tr>
<td><?php header("Content-type: mysql_result
($result, 0 ,'filetype')");?>
</td>
</tr>
<tr>
</tr>
<tr>
<td><?php echo "id: $tableid "; ?></td>
</tr>
<tr>
<td><?php echo "description: $row[description] "; ?></td>
</tr>
<tr>
<td><?php echo "file name: $row[filename] "; ?>
</td>
</tr>
<tr>
<td><?php echo "file size:$row[filesize] "; ?></td>
</tr>
<tr>
<td><?php echo "file type :$row[filetype] "; ?></td>
</tr>
<?php die(mysql_error());?>
}
};

Thank you very much.

SpecialFX

Well, from what I can see did you ever even connect to the db? Then you never closed your php before you opened a new one.

f($id == $tableid)
{


echo mysql_result($result, 0 ,"bin_data");

Right after this you didn't close your PHP script or you if you didn't want to close it then you didn't use use echo. You can't just have HTML inside PHP that isn't being echoed.

<html>
<body>
<table width="100%" hieght="100%" border="2" bordercolor="pink">
<th>

Then here you just opened a new php set and the first one was never closed.

<?php echo "<h2>Item was found</h2><br />"; ?>