Please make a selection in the pull-down menu above";
exit;
}
$limit=5;
$dbasen="gto";
$dbhost="localhost";
$dbuser="erix";
$dbpass="irene500";
$dbconnect=mysql_connect($dbhost,$dbuser,$dbpass);
//**** Radera allt gammalt skit!!
//****
$sqlstr="delete from swapmeet where TO_DAYS(NOW()) - TO_DAYS(date) >=14";
$result=mysql($dbasen,$sqlstr,$dbconnect);
//****
$sqlstr="select * from swapmeet order by date";
if($show_todo=="sale")
{
$sqlstr="select * from swapmeet where todo='For Sale' order by date";
}
if($show_todo=="wanted")
{
$sqlstr="select * from swapmeet where todo='Wanted' order by date";
}
$result=mysql($dbasen,$sqlstr,$dbconnect);
$numrows=mysql_numrows($result);
if (empty($offset)) {
$offset=0;
}
$sqlstr=$sqlstr." limit $offset,$limit";
$result=mysql($dbasen,$sqlstr,$dbconnect);
$antal=mysql_numrows($result);
$raknare=0;
while($raknare<$antal)
{
$todo=mysql_result($result,$raknare,"todo");
$object=mysql_result($result,$raknare,"object");
$email=mysql_result($result,$raknare,"email");
$disc=mysql_result($result,$raknare,"disc");
$price=mysql_result($result,$raknare,"price");
$location=mysql_result($result,$raknare,"location");
$date=mysql_result($result,$raknare,"date");
?>
Price:
Location:
Contact:
Advertisment added
=1)
{ // bypass PREV link if offset is 0
$prevoffset=$offset-$limit;
print "<<Previous \n";
}
// calculate number of pages needing links
$pages=intval($numrows/$limit);
// $pages now contains int of pages needed unless there is a remainder from division
if ($numrows%$limit)
{
// has remainder so add one page
$pages++;
}
for ($i=1;$i<=$pages;$i++)
{ // loop thru
$newoffset=$limit*($i-1);
if ($offset==$newoffset)
{
print ("$i \n");
}
else
{
print "$i \n";
}
}
if (!((($offset+$limit)/$limit)==$pages) && $pages!=1)
{
// not last page so give NEXT link
$newoffset=$offset+$limit;
print "Next»