If you want the actual PHP file then I'll C&P the code.
Don't shout at me though.
<a href="spectra1.jpg" onclick="$j('img#spectra').attr('src','spectra1.jpg').show(); return false">view spectra</a>
<img id="spectra" src="" alt="" style="display:none;"/>
<html> <head> <title>NMR Database</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link href="stylesheet.css" rel="stylesheet" type="text/css" /> </head> <body> <?php mysql_connect("localhost","xxxxxx","******"); mysql_select_db("nmr"); $tableid = $_GET['id']; $query = "SELECT id,code,labbookref,contents,solvent,elements,servercode,time,machine,year,month,nmre1,nmrn1,nmre2,nmrn2,nmre3,nmrn3,nmre4,nmrn4,nmre5,nmrn5 FROM nmr WHERE id=$tableid"; $result = mysql_query($query); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { echo " <table border='0' width='auto' style='margin-left: 0px;'> <tr> <td class='fulltop' width='50px'>{$row['code']}</td> <td class='fulltop' width='50px'>{$row['labbookref']}</td> <td class='fulltop' width='680px' align='right'>{$row['contents']}</td> </tr> </table> <div class='fullmain'> {$row['solvent']}<br /> {$row['elements']}<br /> {$row['year']}<br /> {$row['month']}<br /> <a target='_blank' href='./nmr/{$row['machine']}/{$row['year']}/{$row['month']}/data/AB/nmr/{$row['servercode']}/{$row['nmrn1']}/pdata/1/email_{$row['servercode']}_{$row['nmrn1']}_1.pdf'>{$row['nmre1']}</a><br /> <a target='_blank' href='./nmr/{$row['machine']}/{$row['year']}/{$row['month']}/data/AB/nmr/{$row['servercode']}/{$row['nmrn2']}/pdata/1/email_{$row['servercode']}_{$row['nmrn2']}_1.pdf'>{$row['nmre2']}</a><br /> <a target='_blank' href='./nmr/{$row['machine']}/{$row['year']}/{$row['month']}/data/AB/nmr/{$row['servercode']}/{$row['nmrn3']}/pdata/1/email_{$row['servercode']}_{$row['nmrn3']}_1.pdf'>{$row['nmre3']}</a><br /> <a target='_blank' href='./nmr/{$row['machine']}/{$row['year']}/{$row['month']}/data/AB/nmr/{$row['servercode']}/{$row['nmrn4']}/pdata/1/email_{$row['servercode']}_{$row['nmrn4']}_1.pdf'>{$row['nmre4']}</a><br /> <a target='_blank' href='./nmr/{$row['machine']}/{$row['year']}/{$row['month']}/data/AB/nmr/{$row['servercode']}/{$row['nmrn5']}/pdata/1/email_{$row['servercode']}_{$row['nmrn5']}_1.pdf'>{$row['nmre5']}</a><br /> {$row['servercode']} <br /> <br /> <a target='image' href='./nmr/{$row['machine']}/{$row['year']}/{$row['month']}/data/AB/nmr/{$row['servercode']}/{$row['nmrn1']}/pdata/1/email_{$row['servercode']}_{$row['nmrn1']}_1.png'>{$row['nmre1']}</a><br /> <a href='./nmr/{$row['machine']}/{$row['year']}/{$row['month']}/data/AB/nmr/{$row['servercode']}/{$row['nmrn1']}/pdata/1/email_{$row['servercode']}_{$row['nmrn1']}_1.png' onclick='$j('img#spectra').attr('src','./nmr/{$row['machine']}/{$row['year']}/{$row['month']}/data/AB/nmr/{$row['servercode']}/{$row['nmrn1']}/pdata/1/email_{$row['servercode']}_{$row['nmrn1']}_1.png').show(); return false'>{$row['nmre1']} #2</a> <img id='spectra' src='' alt='' style='display:none;'/> </div> <iframe name='image' width='780px' height='550px' frameborder='0' class='fullimage' ></iframe> "; } ?> </body> </html>
<script type="text/javascript" src="jquery-1.2.6.min.js"></script> <script type="text/javascript">$j = jQuery.noConflict();</script>
$prefix = "./nmr/{$row['machine']}/{$row['year']}/{$row['month']}/data/AB/nmr/{$row['servercode']}/";
<script type="text/javascript" src="jquery-1.2.6.min.js"></script> <script type="text/javascript">$j = jQuery.noConflict();</script>
<a href='./nmr/{$row['machine']}/{$row['year']}/{$row['month']}/data/AB/nmr/{$row['servercode']}/{$row['nmrn1']}/pdata/1/email_{$row['servercode']}_{$row['nmrn1']}_1.png' onclick='$j('img#spectra').attr('src','./nmr/{$row['machine']}/{$row['year']}/{$row['month']}/data/AB/nmr/{$row['servercode']}/{$row['nmrn1']}/pdata/1/email_{$row['servercode']}_{$row['nmrn1']}_1.png').show(); return false'>{$row['nmre1']} #2</a> <br /> <img id='spectra' src='' alt='' style='display:none;'/>
<a false="" return="" ).show();="" email_2008-10-09-ab-49_10_1.png="" 1="" pdata="" 10="" 2008-10-09-ab-49="" nmr="" ab="" data="" oct="" 2008="" bruk400data="" .="" ,="" src="" ).attr(="" img#spectra="" onclick="(" href="./nmr/bruk400data/2008/Oct/data/AB/nmr/2008-10-09-AB-49/10/pdata/1/email_2008-10-09-AB-49_10_1.png">F #2</a> <br/> <img id="spectra" style="display: none;" alt="" src=""/>
<a href='./nmr/{$row['machine']}/{$row['year']}/{$row['month']}/data/AB/nmr/{$row['servercode']}/{$row['nmrn1']}/pdata/1/email_{$row['servercode']}_{$row['nmrn1']}_1.png' onclick='$j('img#spectra').attr('src','./nmr/{$row['machine']}/{$row['year']}/{$row['month']}/data/AB/nmr/{$row['servercode']}/{$row['nmrn1']}/pdata/1/email_{$row['servercode']}_{$row['nmrn1']}_1.png').show(); return false'>{$row['nmre1']} #2</a> <br /> <img id='spectra' src='' alt='' style='display:none;'/>
onclick=\"...\"
<a href='$prefix{$row['nmrn1']}/pdata/1/email_{$row['servercode']}_{$row['nmrn1']}_1.png' onclick=\"$j('img#spectra').attr('src','$prefix{$row['nmrn1']}/pdata/1/email_{$row['servercode']}_{$row['nmrn1']}_1.png').show(); return false\">{$row['nmre1']} #2</a> <br /> <img id='spectra' src='' alt='' style='display:none;'/> </span
Still opens the image directly and not within the page.EDITED: 30 Nov 2008 21:46 by ANT_THOMAS
<a href='$prefix{$row['nmrn1']}/pdata/1/email_{$row['servercode']}_{$row['nmrn1']}_1.png' onclick=\"\$j('img#spectra').attr('src', this.href ).show(); return false\">{$row['nmre1']} #2</a>
(That also has the second url replaced with this.href)
Once you've done that it'll work.EDITED: 1 Dec 2008 00:14 by BOUGHTONP
$tableid = $_GET['id']; $query = "SELECT * FROM nmr LIMIT 5 OFFSET $tableid";
select * from nmr where id >= offset limit 5
edit: oh and you prob want a "order by id asc" just to make sure.
$tableid = $_GET['id']; $query = "SELECT * FROM nmr WHERE id >= $tableid LIMIT 5";
$getid = $_GET['id']; $tableid = mysql_escape_string($getid); $query = "SELECT * FROM nmr WHERE id >= $tableid LIMIT 5";