paging results.

[v3nt]

I've never managed to get paging working, not sure what's going wrong but the error is; Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /Reapit/hgasite/htmlbt/search_res4.php on line 24

Any help much appreciated.

Dan.

$threads_per_page = 12;
$increment=1;
$thread_list_offset += $increment*$threads_per_page;

$query_PD = mysql_query("SELECT * FROM property*WHERE*pavailable='1' AND synchDel !='1'
AND paddress1 like\"%$stname%\"
AND pg1=1
ORDER BY pforsdate DESC
LIMIT".($thread_list_offset-1).", ".$threads_per_page);
//
while($myrow_PD = mysql_fetch_array($query_PD)){
$synchDel = $myrow_PD["synchDel"]; 
 $synchRec = $myrow_PD["synchRec"]; 
 $pcode = $myrow_PD["pcode"]; 
 $pavailable = $myrow_PD["pavailable"];
}

[planetsim]

Try running your query in PHPMyAdmin the most obvious error I see is WHERE which should have the "*" without quotes removed on either side, and probably not the reason for the error but still just to clean the query up

like\"%$stname%\"

maybe have a space there like so

like '%".$stname."%'

[v3nt]

thanks. i kinda got something working with-
$threads_per_page = 12;

$increment++;

$thread_list_offset += $increment*$threads_per_page;

$query_PD = "SELECT FROM propertyWHERE*pavailable='1' AND synchDel !='1'
AND paddress1 like\"%$stname%\"
AND pprice>$minprice AND pprice<$maxprice
AND pg5>$MinBedrooms AND pg5<$MaxBedrooms
ORDER BY pforsdate DESC
LIMIT $thread_list_offset, $threads_per_page";

$result_PD = mysql_query($query_PD) or die ("Error in query: $query. " . mysql_error());