this my script.When i do this,it works fine
`
$query = "select * FROM aboutusx order by title desc";
`
but when i do this
$query = "select * FROM aboutusx WHERE myaccountid='$myid' order by title desc";
then i get this
Notice: Undefined variable: start in D:\xampp\htdocs\kwa\admin\userindex\inc\ps_pagination.php on line 176
i need this piece of code myaccountid='$myid'
in order to select data input by user with that id .Am building a cms that require user specific data shown to specific users with specific user id
full code below
$count_num_str='50';
$query = "select * FROM aboutusx WHERE myaccountid='$myid' order by title desc";
$pager = new ps_pagination($conn,$query,50,50);
$rs = $pager->paginate();
while($row = mysql_fetch_assoc($rs))
{
$id = $row['id'];
$page = $row['title'];
$category = substr($row['pagecontent'],0, $count_num_str);
$isshow = $row['isshow'];
echo"
<table width='100%' border='0' cellspacing='1' cellpadding='1'>
<tr bgcolor='#FFECD9'>
<td width='7%' align=center class=fonts><a href=aboutusx.php?nav=edit&id=$id&page=$page&category=$category><img src='img/icon/edit.gif' width='18' height='18' border='0' /></a></td>
<td width='25%' align='left' class='bodyTxt'> $page</td>
<td width='25%' align='justify' class='bodyTxt'> $category ...</td>
<td width='25%' align='center' class='bodyTxt'> $isshow</td>
<td width='7%' align='center'><a href=delete.php?nav=del&id=$id>
<img src='img/icon/delete.gif' width='18' height='18' border='0' /></a></td>
</tr>
<tr bgcolor=#FF9933 align=center>
<td colspan=14><div align=center><img src=/img/spacer.gif width=1 height=1></div></td>
</tr>
";
}
//Display the full navigation in one go
echo"<tr><td class='bodyTxt' colspan='14' align='center'><br>".$pager->renderFullNav(). "</td></tr></table>";