Dynamic menus and blob problems

Glen_B_

Hi all

I am reasonably new at php.

I have a database table with three fields, id, caption and data. I have used the id and caption to create a dynamic menu. it just throws it into a loop with extra html formatting stuff. No problem.

The data field is a large blob. The data is a complete html file which comes out of a timing system for race cars, its basically a big table.

How do I render the blob data within the current window or in a new window when the link is clicked, its got me stumped. I have used php to bring the page together using include statements, header footer and side_nav. the menu gets produced in side_nav.

Please help, I'm stuck.

Hiccup

$blob_data = $your_row['blob_data'];
include("header.inc");
echo "$blob_data";
include("footer.inc);

That is an easy one I think...?

Glen_B_

Thanks for that but how exactly do i intergrate it into this so it acts like a normal hyperlink.

//display the information
$result = mysql_query ("SELECT id, res_caption, res_data FROM results");
while($row = mysql_fetch_array($result))
{
echo ("<tr><td><a target=_blank href='#'>".$row["res_caption"]. " </a></td></tr>");
}
//close user connection
mysql_close();
?>

steve8557

You need to output the href link and point it to your blob display page passing it the record id. like this:

while($row = mysql_fetch_array($result))  

 { 
 echo ("<tr><td><a target=_blank href=\"blob_display.php?id=" . $row["res_id"] . ">".$row["res_caption"]. "_</a></td></tr>"); 
 }

Once you're in the blob_display.php and have the res_id you can issue a further query on the database to get the blod data. Like this:

$blob_sql = "select res_data from results where res_id = '$id'";

$res_data = $your_row['res_data']; 

include("header.inc"); 
echo $res_data; 
include("footer.inc);

That should work.

Regards
Steve