<?php
include "../inc/connect.php";
$query = "SELECT fullsize FROM table1,table2 WHERE id='%'";
$result = mysql_query( $query );
if ( !$result ) {
die($query.'<br />'.mysql_error());
}
// Build Table
while( $row = mysql_fetch_assoc( $result ) ) {
echo "<br /><br />$row[fullsize]";
}
?>
thats the code, what i want it to do is echo the fullsize of the image to the page when the url is view.php?id=1 or id=2 or id=3, etc...
the data thats in the fullsize field is this:
<img border='0' src='http://mysite.com/image.jpg'>
by the way, im querying two tables because they both contain fullsize images i need to echo on that page when the url is view.php?id=1, 2, etc...
the two tables have the same exact field names too. they just have different data in the fields. table1 contains id's 1-20 and table2 contains id's 21-40.
can anyone help me? please i been trying to figure this out for a long time kthanks.
