ja okay, undskyld det har taget noget tid. den henter alt dataen men nar jeg trykker pa side skift bliver den bare staende ... kig pa dette example her som virker
example: www.thebbzor.co.uk/test/manor.php
da jeg oploaded den til min work host kom jeg i problemer med fQrst ville den ikke opdate dataen. som jeg sa fandt en anden mAde at skrive det pa virker fint men nu nar jeg trykker pa next eller i search virker den ikke. kig pa dette example som er ikke virker.
www.isales-online.com/manor.php
jeg tror selv problemet ligger her
<?
if(!$rows) $rows = 0;
if(!$HTTP_GET_VARS['i'] == "search")
{
$get_manor = mysql_query("select * from manor ORDER BY id asc limit $rows, 1000") or die(mysql_error());
$get_manor2 = mysql_query("select * from manor ORDER BY id asc") or die(mysql_error());
}
else
{
$get_manor = mysql_query("select * from manor WHERE id like '%".$search."%' OR status like '%".$search."%' OR title like '%".$search."%' OR fname like '%".$search."%' OR housenn like '%".$search."%' OR address like '%".$search."%' OR postcode like '%".$search."%' OR phone like '%".$search."%' order by id limit $rows, 200") or die(mysql_error());
$get_manor2 = mysql_query("select * from manor WHERE id like '%".$search."%' OR status like '%".$search."%' OR title like '%".$search."%' OR fname like '%".$search."%' OR housenn like '%".$search."%' OR address like '%".$search."%' OR postcode like '%".$search."%' OR phone like '%".$search."%' order by id") or die(mysql_error());
}
$numrows = mysql_num_rows($get_manor2);
$line = 1;
while($manor = mysql_fetch_assoc($get_manor))
{
if($line == 1)
{
$bgcol = "#EAEAEA";
}
else
{
$line = 0;
$bgcol = "#EFEFEF";
}
echo '<tr><td bgcolor="'.$bgcol.'"><a href="?i=info&id='.$manor[id].'" class="listlink">'.$manor[id].'</a></td><td bgcolor="'.$bgcol.'"><a href="?i=info&id='.$manor[id].'" class="listlink">'.$manor[status].'</a></td><td bgcolor="'.$bgcol.'"><a href="?i=info&id='.$manor[id].'" class="listlink">'.$manor[title].'. '.$manor[fname].'</a></td><td bgcolor="'.$bgcol.'"><a href="?i=info&id='.$manor[id].'" class="listlink">'.$manor[housenn].' '.$manor[address].'</a></td><td bgcolor="'.$bgcol.'"><a href="?i=info&id='.$manor[id].'" class="listlink">'.$manor[postcode].'</a></td><td bgcolor="'.$bgcol.'"><a href="?i=info&id='.$manor[id].'" class="listlink">'.$manor[phone].'</a></td><td bgcolor="'.$bgcol.'"><a href="?i=info&id='.$manor[id].'" class="listlink">'.$manor[addstatus].'</a></td></tr>';
$line+1;
}
echo "<tr><td align='left' colspan='3'>";
if($rows > 1000)
{
echo "<a href='?rows=".($rows-1000)."'>Previous Page(".($rows-1099)."-".$rows.")</a>";
}
echo "</td><td align='right' colspan='4'>";
if($rows+14<$numrows)
{
if($rows+28 > $numrows)
{
echo "<a href='?rows=".($rows+1000)."'>Next Page(".($rows+1001)."-".($numrows).")</a>";
}
else
{
echo "<a href='?rows=".($rows+1000)."'>Next Page(".($rows+1001)."-".($rows+2000).")</a>";
}
}
}
?>