Photos aren't disappearing??? MUST BE SOLVED SOON!

[cturner]

My code below displays everything ok up until the photos that aren't changing when I click the next link. Can someone please have a look at my code and tell me how I can make the photos disappear when going to another page? Thanks in advance.

 

If you need to see my table structure, here it is:

ruralproperties

id // autoincrement

// rest isn't relevant

 

ruralproperties_photos

photos_id //autoincrement

parent_id

photos

filename

 

I somehow feel that it could be something to do with the parent_id. I don't know how any better way of getting the parent_id from the table.

 

require "config.php";
if(!isset($_GET['page'])) {
    $page = 1;
} else {
    $page = $_GET['page'];
}

// Define the number of results per page
$max_results = 1;

// Figure out the limit for the query based
// on the current page number
$from = (($page * $max_results) - $max_results);

// Perform MySQL query on only the current page number's results
$sql = mysql_query("SELECT * FROM `ruralproperties`, `ruralproperties_photos` LIMIT $from, $max_results") or die ("Could not query because: " . mysql_error());

while($row = mysql_fetch_array($sql)){
    $propertyname = stripslashes($row['propertyname']);
    $message1 = stripslashes($row['message1']);
    $message2 = stripslashes($row['message2']);
    $message3 = stripslashes($row['message3']);
    $message4 = stripslashes($row['message4']);
    $message5 = stripslashes($row['message5']);
    $message6 = stripslashes($row['message6']);
    $message7 = stripslashes($row['message7']);
    $message8 = stripslashes($row['message8']);
    $message9 = stripslashes($row['message9']);
    $message10 = stripslashes($row['message10']);
    $message11 = stripslashes($row['message11']);
    $message12 = stripslashes($row['message12']);
    $message13 = stripslashes($row['message13']);
    $message14 = stripslashes($row['message14']);
    $message15 = stripslashes($row['message15']);
    $message16 = stripslashes($row['message16']);
    $message17 = stripslashes($row['message17']);
    // Build your formatted results here
    echo "<center><b>".$propertyname."</b></center>";
    echo "<table width=100% border=0 cellspacing=0 cellpadding=0>";
    echo '<tr>';
    echo '<td width=20% valign=top><div class=titletxt>'.$row['category1'].'</div></td>';
    echo '<td width=50% valign=top>'.$message1.'</td></tr>';
    echo '<tr><td valign=top><div class=titletxt>'.$row['category2'].'</div></td>';
    echo '<td valign=top>'.$message2.'</td></tr>';
    echo '<tr><td valign=top><div class=titletxt>'.$row['category3'].'</div></td>';
    echo '<td valign=top>'.$message3.'</td></tr>';
    echo '<tr><td valign=top><div class=titletxt>'.$row['category4'].'</div></td>';
    echo '<td valign=top>'.$message4.'</td></tr>';
    echo '<tr><td valign=top><div class=titletxt>'.$row['category5'].'</div></td>';
    echo '<td valign=top>'.$message5.'</td></tr>';
    echo '<tr><td valign=top><div class=titletxt>'.$row['category6'].'</div></td>';
    echo '<td valign=top>'.$message6.'</td><tr>';
    echo '<tr><td colspan=4 valign=top></td></tr>';
    echo '<tr><td width=14% valign=top><div class=titletxt>'.$row['category7'].'</div></td>';
    echo '<td colspan=3 valign=top>'.$message7.'</td></tr>';
    echo '<tr><td valign=top><div class=titletxt>'.$row['category8'].'</div></td>';
    echo '<td colspan=3 valign=top>'.$message8.'</td></tr>';
    echo '<tr><td valign=top><div class=titletxt>'.$row['category9'].'</div></td>';
    echo '<td colspan=3 valign=top>'.$message9.'</td></tr>';
    echo '<tr><td valign=top><div class=titletxt>'.$row['category10'].'</div></td>';
    echo '<td colspan=3 valign=top>'.$message10.'</td></tr>';
    echo '<tr><td valign=top><div class=titletxt>'.$row['category11'].'</div></td>';
    echo '<td colspan=3 valign=top>'.$message11.'</td></tr>';
    echo '<tr><td valign=top><div class=titletxt>'.$row['category12'].'</div></td>';
    echo '<td colspan=3 valign=top>'.$message12.'</td></tr>';
    echo '<tr><td valign=top><div class=titletxt>'.$row['category13'].'</div></td>';
    echo '<td colspan=3 valign=top>'.$message13.'</td></tr>';
    echo '<tr><td valign=top><div class=titletxt>'.$row['category14'].'</div></td>';
    echo '<td colspan=3 valign=top>'.$message14.'</td></tr>';
    echo '<tr><td valign=top><div class=titletxt>'.$row['category15'].'</div></td>';
    echo '<td colspan=3 valign=top>'.$message15.'</td></tr>';
    echo '<tr><td valign=top><div class=titletxt>'.$row['category16'].'</div></td>';
    echo '<td colspan=3 valign=top>'.$message16.'</td></tr>';
    echo '<tr><td valign=top><div class=titletxt>'.$row['category17'].'</div></td>';
    echo '<td colspan=3 valign=top>'.$message17.'</td></tr>';
    echo '</table><br />';
    $parent_id = $row['parent_id'];
echo "Click on the image to see the larger image.<br />";
echo "These photos are for the Braylee property.<br />";

$query = mysql_query("SELECT * FROM `ruralproperties_photos` WHERE `parent_id` = '$parent_id'") or die ("Could not query because: " . mysql_error());
while ($row = mysql_fetch_array($query)) {
    echo '<a href=# onClick="popWin(\''.$row['filename'].'.htm\', \'\', \'640\', \'480\')"><img src=http://www.houlahanyoung.com.au/images/'.$row['photos'].' border=0 /></a> ';
}
}

if (mysql_affected_rows() == 0) {
    print "No properties to be displayed.";
}

// Figure out the total number of results in DB:
$total_results = mysql_result(mysql_query("SELECT COUNT(*) AS Num FROM `ruralproperties`"),0) or die ("Could not query because: " . mysql_error());

// Figure out the total number of pages. Always round up using ceil()
$total_pages = ceil($total_results / $max_results);

// Build Page Number Hyperlinks
echo "<center>";

if ($page == 1) {
    echo "Previous ";
} else {
    echo "<a href=\"".$_SERVER['PHP_SELF']."?page=".($page-1)."\">Previous</a> ";
}

for($i = 1; $i <= $total_pages; $i++){
    if(($page) == $i){
        echo "$i ";
        } else {
            echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> ";
    }
}

if ($page == $total_pages) {
    echo " Next";
} else {
    echo " <a href=\"".$_SERVER['PHP_SELF']."?page=".($page+1)."\">Next</a>";
}

echo "</center>";
mysql_close(); 

[btherl]

You should order your results when doing paging, otherwise mysql is free to return them in any order.

 

Edit:  Do you want the photos only on the first page, and on subsequent pages display no photos at all?

[cturner]

Edit:  Do you want the photos only on the first page, and on subsequent pages display no photos at all?

 

Yes that is kind of right but each property listing (messages) suppose to have matching photos that are to be displayed.