Page 1 of 1

php paging

Posted: Fri Jul 01, 2005 1:25 pm
by prasaderandi
i wrote a php coding but its not working if i'm using where
clause can you help me whats wrong
function coding is function pc_print_link($inactive,$text,$offset='')
{
if($inactive)
{
printf('<font color="#666666">%s</font>',$text);
}
else
{
printf('<a href="%s?offset=%d">%s</a>',$_SERVER['PHP_SELF'],$offset,$text);
}
}// end of function


function pc_indexed_links($total,$offset,$perpage)
{
$separator='|';
//print prev link

pc_print_link($offset==1,'<<Prev',$offset-$perpage);
//print all groupings except last one
for($start=1,$end=$perpage;$end<$total;$start+=$perpage,$end+=$perpage)
{

print $separator;
pc_print_link($offset==$start,"$start-$end",$start);

}
//end for loop
$end=($total > $start)?"-$total":'';
print $separator;
pc_print_link($offset==$start,"$start$end",$start);
//print next >> link
print $separator;


pc_print_link($offset==$start,'Next>>',$offset+$perpage);

}


my sql statement is
select * from friend where (age=$age and sex='$seek') order by username limit $offset1,$perpage";
but if i remove where clause its working proprly. help me

Posted: Fri Jul 01, 2005 1:27 pm
by Sphen001
Hi,

If you need to change something in your post, please try and use the edit button instead of creating a new topic. :D

Sphen001

sorry

Posted: Fri Jul 01, 2005 1:29 pm
by prasaderandi
sorry i'm new to ure site its never happen again

Posted: Fri Jul 01, 2005 2:17 pm
by John Cartwright
DO NOT CROSS POST.
Topic Locked.