move next move previous help.

[aron]

this is my sql

if($page_from == 'land.php'){
$sqlviewnp = "SELECT * FROM Listings WHERE status<>'sold' AND type NOT IN ('Business', 'House', 'Apartment', 'Acreage', 'Duplex', 'Rental House', 'Rental Unit', 'Commercial Retail', 'Commercial Offices', 'Commercial Industrial', 'Retirement', 'Riverfront Home', 'Studio', 'Townhouse', 'Unit', 'Villa' )";
}
$sql_resultviewnp = mysql_query($sqlviewnp,$connection) or die ("Could not connect to database 1id");
$lineviewnp = mysql_fetch_array($sql_resultviewnp);

and i have two buttons on my page.

view next
<a href="prop.php?property_id=<? print $lineviewnp["id"]+1; ?>" class="menubold" onMouseOver="MM_swapImage('Image4','','img/stargreen.gif',1)" onMouseOut="MM_swapImgRestore()">View
Next </a>

view previous
<a href="prop.php?property_id=<? print $lineviewnp["id"]-1; ?>" class="menubold" onMouseOver="MM_swapImage('Image4','','img/stargreen.gif',1)" onMouseOut="MM_swapImgRestore()">View
Previous </a>

but it dosent work. what am i doing wrong.

cheers aron.

[aron]

cheers aron.

[PHPGuru2]

I think you need to specity property_id in your SQL.

$query = "SELECT * FROM table WHERE ... AND property_id = '"+ $_GET['property_id'] +"'";

This will fetch data where property_id is the value in $_GET['property_id'].