paging problem

thread_PHP

pages are crashing.
<< 1|2|3 >> when u click
on the 3rd link it is going to 5 th page.

the problem comes when the Listings per page: is
selected to 1 or 2.

anybody please help me

brandtj

When I do a page number script it's generally something like this:

$perpage = 10;

$query = get the id of every row in the table;
$total = num_rows in $query;

$pages = ceil ($total / $perpage);
$pagenum = $_GET['page'];

$start = ($pagenum - 1) * $perpage;

$query = 'select limit ' . $start . ',' . $perpage;
$result = mysql_query ($query);

// and the rest is history

It looks like you've rigged yours up a bit differently and to be perfectly honest I'm having a tiny bit of trouble following it. 🙁 You'll have to excuse me, it's always hard to read someone elses code, haha.

I hope this helps. 🙂

thread_PHP

hi brandtj
please check my code and help me please.please post the code to chekck.

Shrike

When I open your attached file in either Windows or Unix format, I see all of the formatting instructions for the text, e.g.

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Courier

If you attach a plain text file I'll take a look.

thread_PHP

<?
include "dbconnect.inc.php";
if($_REQUEST["searchparameters"]=="")
{
	$searchparameters=$_POST["searchparameters"];
}
else
{
	$searchparameters=$_REQUEST["searchparameters"];
}	
?>

<SCRIPT LANGUAGE=javascript>
<!--
function dispResultsPerPage(list)
{
	alert(list.options[list.selectedIndex].value);
	document.form1.action=list.options[list.selectedIndex].value;
	document.form1.method="post";
	document.form1.submit();
}

function jumpBox(list) {
document.form1.action=list.options[list.selectedIndex].value;
document.form1.submit();
}


function submitForm()
{
	document.form1.action="search_results.php";
	document.form1.method="post";
	document.form1.submit();
}

function loadPage(argParams)
{
	document.form1.action=argParams;
	document.form1.method="post";
	document.form1.submit();
}
function loadPage1(url, name)
{
	//document.form1.action=argParams1;
	//document.form1.method="post";
	//document.form1.submit();
	popupWin = window.open(url, name, 'dependent,scrollbars=no,resizable=no,width=350,height=350,left=150,top=50')
}
//-->
</SCRIPT>

thread_PHP

HI shrike
POSTING THE SECOND PART OF THE CODE

<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
}
.style2 {color: #018b08}
-->
</style>
<link href="css/kw.css" rel="stylesheet" type="text/css">
</head>

<body>
<table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td colspan="3"><? include ("header.php") ?></td>
  </tr>
  <tr>
    <td colspan="3">
	<? include ("middle.php") ?>

</td>
  </tr>
  <tr>
    <td></td>
    <td class="headng">&nbsp;</td>
    <td></td>
  </tr>
   <?
    $filestr = "result_details1.php?".$_ENV["QUERY_STRING"];
	$script="result_details1.php";
	$profession = $_REQUEST["profession"];
	print $profession;
	$speciality = $_REQUEST["speciality"];
	$language = $_REQUEST["language"];
	$country = $_REQUEST["country"];
	$state = $_REQUEST["state"];
	$district = $_REQUEST["district"];
	$localcity = $_REQUEST["localcity"];
	$zipcode = $_REQUEST["zipcode"];
	$cnt1=$_REQUEST["cnt"];

$day1=$_REQUEST['selday1'];
$clause1=$_REQUEST['ab'];
$fromhr=$_REQUEST['selfromhr1'];
$tohr=$_REQUEST['seltohr1'];
$dirID = $_REQUEST['dirID'];

 $sql1 = "select proftype from kw_profession_master where profid=$profession";
//	 print $sql1;
	 $rs1 = mysql_query($sql1);
	 $proftype = mysql_fetch_row($rs1);

 $sql1 = "select country_name from kw_country_master where country_id=$country";
 $rs1 = mysql_query($sql1);
 $othercountry=mysql_fetch_row($rs1);
 if($_REQUEST["pageno"] == "")
 {
 	$pagenumber = 1;
 }
 else
 {
 	if($_REQUEST["Nav"] == "P")
	{
		$pagenumber = $_REQUEST["pageno"] - 1;
	}
	elseif($_REQUEST["Nav"] == "N")
	{
 		$pagenumber = $_REQUEST["pageno"] + 1;
	}	
	else
	{
		$pagenumber = $_REQUEST["pageno"];
	}
 }

 if($language<>0)
 {
	 $sql1 = "select language from kw_language_master where lang_id=$language";
	 $rs1 = mysql_query($sql1);
	 $lang=mysql_fetch_row($rs1);
 }

 if($speciality<>0)
 {
	 $sql1 = "select specname from kw_speciality_master where specid=$speciality";
	 $rs1 = mysql_query($sql1);
	 $otherspeciality=mysql_fetch_row($rs1);
 }


if($state <> 0)
{
	 $sql1 = "select state from kw_state_master where state_id=$state";
	 $rs1 = mysql_query($sql1);
	 $otherstate=mysql_fetch_row($rs1);
}

if($district<>0)
{
	 $sql1 = "select dist_name from kw_district_master where dist_id=$district";
	 $rs1 = mysql_query($sql1);
	 $otherdistrict=mysql_fetch_row($rs1);
}

					if($_REQUEST["offset"]=="")
					{
						$offset=0;
					}
					else
					{
						$offset=$_REQUEST["offset"];
					}

					if($_REQUEST["item_perpage"]=="")
					{
						$item_perpage = 2;
					}
					else
					{
						$item_perpage = $_REQUEST["item_perpage"];
					}


//						print("Offset=".$offset."<br>");
//						$item_perpage= 2;   #----change this to define how many item per page
						$prev= $offset-$item_perpage;
						$next= $offset+$item_perpage;
						$case1 = $_REQUEST['case1'];

					 $sql = "select * from kw_malayalee_directory where tprofession=$profession and (country=$country or other_country='$othercountry[0]') and active='Yes'";
					 $sql1 = "select count(*) from kw_malayalee_directory where tprofession=$profession and (country=$country or other_country='$othercountry[0]') and active='Yes'";
					 $sql2 = "select directory_id from kw_malayalee_directory where tprofession=$profession and (country=$country or other_country='$othercountry[0]') and active='Yes'";

					 $BasicURL = "profession=$profession&country=$country&case1=$case1&dirID=$dirID";
					 if($speciality<>0)
					 {
						$sql = $sql." and (speciality=$speciality or other_speciality='$otherspeciality[0]')";
						$sql1 = $sql1." and (speciality=$speciality or other_speciality='$otherspeciality[0]')";
						$sql12 = $sql12." and (speciality=$speciality or other_speciality='$otherspeciality[0]')";
						$BasicURL = $BasicURL."&speciality=$speciality";
					 }

					 if($language<>0)
					 {
						$sql = $sql. " and (langauge1 like '$lang[0]' or langauge2 like '$lang[0]' or langauge3 like '$lang[0]' or langauge4 like '$lang[0]' or langauge5 like '$lang[0]' or langauge6 like '$lang[0]' or langauge7 like '$lang[0]' or other_language like '$lang[0]')";
						$sql1 = $sql1. " and (langauge1 like '$lang[0]' or langauge2 like '$lang[0]' or langauge3 like '$lang[0]' or langauge4 like '$lang[0]' or langauge5 like '$lang[0]' or langauge6 like '$lang[0]' or langauge7 like '$lang[0]' or other_language like '$lang[0]')";
						$sql12 = $sql12. " and (langauge1 like '$lang[0]' or langauge2 like '$lang[0]' or langauge3 like '$lang[0]' or langauge4 like '$lang[0]' or langauge5 like '$lang[0]' or langauge6 like '$lang[0]' or langauge7 like '$lang[0]' or other_language like '$lang[0]')";
						$BasicURL = $BasicURL."&language=$language";
					 }



					switch ($case1) {
					case 1:
						$sql = $sql;
						$sql1 = $sql1;
						$sql2 = $sql2;
						$BasicURL=$BasicURL."&cnt=$cnt1&dirID=$dirID";
						break;
					case 2:
						$sql = $sql." and zip_code='$zipcode'";
						$sql1 = $sql1." and zip_code='$zipcode'";
						$sql2 = $sql2." and zip_code='$zipcode'";
						$BasicURL = $BasicURL."&zipcode=$zipcode";
						break;
					case 3:
						$sql = $sql." and local_city='$localcity'";
						$sql1 = $sql1." and local_city='$localcity'";
						$sql2 = $sql2." and local_city='$localcity'";
						$BasicURL = $BasicURL."&localcity=$localcity";
						break;
					case 4:
						$sql = $sql." and (metro=$district or other_metro='$otherdistrict[0]')";
						$sql1 = $sql1." and (metro=$district or other_metro='$otherdistrict[0]')";
						$sql2 = $sql2." and (metro=$district or other_metro='$otherdistrict[0]')";
						$BasicURL = $BasicURL."&district=$district";
						break;
					case 5:
						$sql = $sql." and (state=$state or other_state='$otherstate[0]')";
						$sql1 = $sql1." and (state=$state or other_state='$otherstate[0]')";
						$sql2 = $sql2." and (state=$state or other_state='$otherstate[0]')";
						$BasicURL = $BasicURL."&state=$state";
						break;
					case 6:
						$sql = $sql." and directory_id IN ($dirID)";
						$sql1 = $sql1." and directory_id IN ($dirID)";
						$sql2 = $sql2." and directory_id IN ($dirID)";
						$BasicURL = $BasicURL."&selday1=$day1&ab=$clause1&selfromhr1=$fromhr&seltohr1=$tohr&dirID=$dirID";
						break;
					}
					$BasicURL = urlencode($BasicURL);
//						print "BURL==".$BasicURL;
//						print $sql2;
						print "CSQL==".$sql;
						$rs = mysql_query($sql2);
						$i=0;
						while($idrow = mysql_fetch_array($rs))
						{
							if($i==0)
							{
								$arrDirectoryId = $idrow["directory_id"];
							}
							else
							{
								$arrDirectoryId = $arrDirectoryId.",".$idrow["directory_id"];
							}	
							$i++;
						}	
						//print($arrDirectoryId);
						//print $sql."<br>";

thread_PHP

HI SHRIKE
POSTING THIRD PART

						#---------------------------------------query configuration

					$query=$sql." order by listing_date LIMIT $offset, $item_perpage";
					//print $query."<br>";
       				$details = mysql_query($query);
					$val = (integer) mysql_num_rows($details);
					//print "rowcount=".mysql_num_rows($details)."<br>";
  					if ($val == 0)
					{
					$dispstatus="";
					}
        			else
					{
					$dispstatus= "display:none";
					$total= @mysql_fetch_row(mysql_query($sql1));
					#echo $total;
					#----modify the where clause to fit your query need

						#---------------------------------------page map

					$pages = (int) ($total[0] / $item_perpage);
					if ($total[0] % $item_perpage) {$pages++;}
					$pno=1;

	/******	working
					for ($a=1;$a<=$pages;$a++) {
						if($a == $pagenumber)
						{
							$map[$a] ="$a";
						}
						else
						{
							$map[$a] ="<a href=javascript:loadPage(\"$script?offset=$offset2&$BasicURL&pageno=$pno&item_perpage=$item_perpage\")>$a</a>";
						}
						$offset2+=$item_perpage;
						$pno++;
					}
	*/

					for ($a=$pagenumber;$a<=($pagenumber+2);$a++) {

					print "Val 1 ==".($item_perpage*$a)." === Val 2 ==".$total[0]."<br>";

					if($a == $pagenumber)
					{
						$map[$a] ="$a";
					}
					else
					{
						$map[$a] ="<a href=javascript:loadPage(\"$script?offset=$offset2&$BasicURL&pageno=$a&item_perpage=$item_perpage\")>$a</a>";
					}

					if(($item_perpage*$a) > $total[0])
					{
						break;
					}

					print "Pagenumber = ".$pagenumber."<br>";
					$offset2+=$item_perpage*$pagenumber;
					print "Offset == ".$offset2."<br>";
					$pno++;

				}




/*						
						for ($a=1;$a<=$pages;$a++) {
							if($a == $pagenumber)
							{
								$map[$a] ="$a";
							}
							else
							{
								$map[$a] ="<a href=javascript:loadPage(\"$script?offset=$offset2&$BasicURL&pageno=$pno&item_perpage=$item_perpage\")>$a</a>";
							}
							$offset2+=$item_perpage;
							$pno++;
						}
	*/					
						if($item_perpage == $total[0])
						{
							$map[1]="";
						}

					/*
					for ($a=1;$a<=$pages;$a++) {
						if($pages!=1)
						{
							if($a!=$pageno){
							$map[$a] ="<a href=javascript:loadPage(\"$script?offset=$offset2&$BasicURL&pageno=$pno&item_perpage=$item_perpage\")>$a</a>";
							}
							else
							{
							$map[$a] ="$a";
							}
						}
						else
						{
							$map[$a]="";
						}
						$offset2+=$item_perpage;
						$pno++;
					}
					*/
					$pagemap=implode(" | ", $map);

thread_PHP

HI SHRIKE
POSTING FOURTHPART

		#---------------------------------------prev next condition
							/*
							if ($prev < 0)
							{
								$prev="";
							}
							else
							{
								$prev="<a href=javascript:loadPage(\"$script?offset=$prev&$BasicURL&item_perpage=$item_perpage&cnt=$cnt1&Nav=P&pageno=$pagenumber\")> <<  Prev Page </a>";
							}

						if ($total[0] > $next)
						{
							$next="<a href=javascript:loadPage(\"$script?offset=$next&$BasicURL&pageno=$pagenumber&item_perpage=$item_perpage&cnt=$cnt1&Nav=N\")> Next Page  >></a>";
							}
						else
						{
							$next="";
						}
						*/
						if($pagenumber == 1)
						{
							$prev="";
						}
						else
						{
							$prev="<a href=javascript:loadPage(\"$script?offset=$prev&$BasicURL&item_perpage=$item_perpage&cnt=$cnt1&Nav=P&pageno=$pagenumber\")> <<  Prev Page </a>";
						}

						if($pagenumber == $pages)
						{
							$next = "";
						}		
						else
						{
							$next="<a href=javascript:loadPage(\"$script?offset=$next&$BasicURL&pageno=$pagenumber&item_perpage=$item_perpage&cnt=$cnt1&Nav=N\")> Next Page  >></a>";							
						}	

						$data=mysql_query($query);
					$no=1;
					?>
  <tr>
    <td width="15"></td>
    <td width="750" class="headng"><div align="center">
	 <form name="form1" method="post" action="">
	 <input type="hidden" name="searchparameters" value="<?=$searchparameters?>">
	 <input type="hidden" name="filestr" value="<?=$filestr?>">
	 <input type="hidden" name="arrDirectoryID" value="<?=$arrDirectoryId?>">
      <table width="740" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td height="18" colspan="3" class="bdr1"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td colspan="3"><div align="center" class="txtred"><u>Search Result for <? echo $proftype[0]; ?> in 
			  <? 
			  if($_REQUEST['cnt']=="zip")
			  {
			  $navurl="prof=". $proftype[0]."&area=". $zipcode;
			  echo $zipcode;
			  }
			  elseif($_REQUEST['cnt']=="local")
			  {
			  $navurl="prof=". $proftype[0]."&area=". $localcity;
			  echo strtoupper($localcity);
			  }
			  elseif($_REQUEST['cnt']=="district")
			  {
			  $navurl="prof=". $proftype[0]."&area=". $otherdistrict[0];
			  echo strtoupper($otherdistrict[0]);
			  }
			  elseif($_REQUEST['cnt']=="state")
			  {
			  $navurl="prof=". $proftype[0]."&area=". $otherstate[0];
			  echo strtoupper($otherstate[0]);
			  }
			  else
			  {
			  $navurl="prof=". $proftype[0]."&area=". $othercountry[0];
			  echo strtoupper($othercountry[0]);
			  }
			   ?></u></div><br></td>
              </tr>
            <tr>
              <td colspan="3" height="10"></td>
              </tr>

thread_PHP

HI SHRIKE
POSTING FIFTH PART

            <tr>
              <td width="31%"><div align="left"><u><a href="index1.php">Home Page</a></u>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div><br></td>
              <td width="35%"><div align="center"><u><a href="search_directory.php">Search Again</a> </u>
              </div><br></td>
              <td width="34%" valign="bottom">
			  <div align="left" class="txt">
               Listings per page: &nbsp;                 

			   <? 
			   $BasicURL = urldecode($BasicURL); 
			   ?>
               <select name="select1" onchange="dispResultsPerPage(this.form.elements['select1'])">
					<?
					$pageno=$total[0]/$_REQUEST['item_perpage'];					
					if($total[0] == 1)
					{
					?>
					  <option value="1">1</option>
					  </select>
					 <?
					 }
					 elseif($total[0]>2 && $total[0]<25)
					 {
					 ?>
			          <option value="<? echo $script;?>?<? echo $BasicURL; ?>&cnt=<? echo $_REQUEST['cnt'];?>&pageno=1&item_perpage=<?=$total[0]?>&sel=all" selected>All</option>
					 <? 
					 $totrecords = $total[0]-1;
					 }
					 elseif($total[0]>25)
					 {
					  for($i=1;$i<=25;$i++)
					  {
					  ?>
						  <option value="<? echo $script;?>?<? echo $BasicURL; ?>&cnt=<? echo $_REQUEST['cnt'];?>&pageno=1&item_perpage=<?=$i?>"

				  <? if ($i==$_REQUEST['item_perpage'] || $i==$item_perpage)
				  {
				  ?>selected
				  <?
				  }

				  ?>><? echo ($i);?></option>
					  <?
				  }
				 }
				 else
				 {
					 $totrecords = $total[0];
				 }
				  ?>
			      <?
				  if($total[0] != 1)
				  {
				  for($i=1;$i<=$totrecords;$i++)
				  //for($i=1;$i<=25;$i++)
				  {
				  ?>
					  <option value="<? echo $script;?>?<? echo $BasicURL; ?>&cnt=<? echo $_REQUEST['cnt'];?>&pageno=1&item_perpage=<?=$i?>"

				  <? if ($i==$_REQUEST['item_perpage'] || $i==$item_perpage)
				  {
				  ?>selected
				  <?
				  }

				  ?>><? echo ($i);?></option>
					  <?
				  }
				  ?>
	              </select>
				  <?
				  }
				  ?>


          </div><br>
		  </td>
        </tr>
					<?
			if(($total[0]%$item_perpage)==0)
			{
				$lastnum = ($item_perpage*$pagenumber);
			}
			else
			{
				if($pages == $pagenumber)
				{
					$lastnum = "";
					$lastnum = $total[0];
					//$total[0];
				}
				else
				{
					$lastnum = ($item_perpage*$pagenumber);
				}
			}
			?>
                    <tr>
                      <td colspan="3" height="5"></td>
                    </tr>

thread_PHP

HI SHRIKE
POSTING SIXTH PART

<tr>
              <td><div align="left" class="txt">Number of listing(s) found: <span class="style2"><?= $total[0];?></span> &nbsp;&nbsp;&nbsp;&nbsp;</div></td>
              <td width="35%"><div align="center"><u><a href="javascript:submitForm();">Search Result</a></u></div>
			 </td>
              <td><div align="left" class="txt">
			  <? 
			  if($total[0] != $item_perpage && $total[0] != 1)
			  {
			  ?>
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Go to the page:&nbsp;&nbsp;
                    <select name="gopage" onChange="jumpBox(this.form.elements['gopage'])">

	      <?
	  for($i=0;$i<$pages;$i++)
	  {
	  ?>
	      <option value="<? echo $script;?>?offset=<? echo ($newoffset);?>&<? echo $BasicURL; ?>&pageno=<? echo $i+1;?>&cnt=<? echo $_REQUEST['cnt'];?>&item_perpage=<? echo $_REQUEST['item_perpage'];?>" 
	   <? if ($pagenumber==$i+1)
		  {
		  ?>selected
		  <?
		  }

		  ?>

	  ><? echo ($i+1);?></option>
	      <?
		  $newoffset +=$item_perpage;
	  }
	  ?>
                </select>

			<?
			}
			?>
          </div></td>
        </tr>
		<tr>
                      <td colspan="3" height="10"></td>
                    </tr>
        <tr>
          <td><div align="left" class="txt">
				<? if($lastnum=="" || $item_perpage==1)
				{
				?>	
				Now displaying listing: <span class="style2"><?=($offset+1)?></span>
				<?		
				}
				else
				{
				?>
				Now displaying listings: <span class="style2"><?=($offset+1)?></span> to <span class="style2"><?=($lastnum)?> </span>
				<?	
				}
				?>
				</div></td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>

		  </td>
          <td></td>
          <td></td>
        </tr>
        <tr>

          <td class="txt"></td>
          <td colspan="2"><div align="right">
		  <? if($total[0] != $item_perpage && $total[0] != 1)
		  {
			echo $prev; ?>&nbsp;&nbsp; <? echo $pagemap; ?>&nbsp;&nbsp; <? echo $next; 
		  }
		  ?>

		</div></td>
          </tr>
      </table></td>
    </tr>


    <tr>
      <td height="2" colspan="3"></td>
    </tr>
	 <tr>
      <td height="2" colspan="3"><div id="nillistings" style=' <? echo $dispstatus; ?> ' align="center">No listings found.</div> </td>
    </tr>
		<?

		while ($myrow = @mysql_fetch_array($data))
		{

		$count=0;
		  if($myrow['photo1']!=""){
		  $count=1;
		  }
		  if($myrow['photo2']!=""){
		  $count=$count+1;
		  }
		  if($myrow['photo3']!=""){
		  $count=$count+1;
		  }
		?>
		<tr>
      <td height="74" colspan="3" valign="top" class="bdr1">

		 <table width="740"  border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="8%">&nbsp;</td>
          <td colspan="9"></td>
          <td width="1%">&nbsp;</td>
          <td width="15%"></td>
          <td width="1%">&nbsp;</td>
          <td width="9%">&nbsp;</td>
        </tr>
        <tr>
          <td rowspan="3" valign="top" class="bdr"><div align="center" class="resultdisplay">
		  <? if($myrow['photo1']=="")
		  {
		  ?>
		  <img src="images/notavailable.jpg" width="50" height="50" class="photoBorder"><br>
		  <?
		  }
		  elseif($myrow['photoaccess']=="Yes")
		  {
		  ?>
		  <a href="javascript:loadPage('listing_details.php?id=<? echo trim($myrow['directory_id']);?>&<? echo $navurl;?>&nolistings=<? echo $total[0]; ?>')">
		  <img src="images/photo-request_small.jpg" class="photoBorder"></a>
		  <?
		  }
		  else
		  {
		  ?>
		  <a href="javascript:loadPage('listing_details.php?id=<? echo trim($myrow['directory_id']);?>&<? echo $navurl;?>&nolistings=<? echo $total[0]; ?>')">
		  <img src="memupload/<? echo trim($myrow['photo1']); ?>" width="50" height="50" style="cursor:hand"></a><br>
		  <?
		  }
		  ?>

		  <?

		  if($count!=0){
		  echo "Album of $count photos";
		  }
		  ?>


			</div></td>
          <td width="1%" rowspan="3" valign="top">&nbsp;</td>
          <td width="8%" valign="top"><div align="left" class="searchhdng">Name:</div></td>
          <td width="15%" valign="top"><div align="left" class="resultdisplay">
		   <? if($myrow['name_profession']=="")
		  {
			echo "Not Available";
		  }
		  else
		  {
		   echo trim($myrow['name_profession']);
		  }
		  ?>

		</div></td>
          <td width="1%" rowspan="3" valign="top">&nbsp;</td>
          <td width="6%" valign="top"><div align="left" class="searchhdng">Phone:&nbsp;</div></td>
          <td width="11%" valign="top"><div align="left" class="resultdisplay">

		  <? if($myrow['phone']=="")
		  {
			echo "Not Available";
		  }
		  else
		  {
		   echo trim($myrow['phone']);
		  }
		  ?>

		 </div></td>
          <td width="1%" rowspan="3" valign="top">&nbsp;</td>
          <td width="5%" valign="top"><div align="left" class="searchhdng">Pager:&nbsp;</div></td>
          <td width="18%" valign="top"><div align="left" class="resultdisplay">
		  <? if($myrow['pager']=="")
		  {
			echo "Not Available";
		  }
		  else
		  {
		   echo trim($myrow['pager']);
		  }
		  ?>

		  </div></td>
          <td rowspan="3" valign="top" width="1%" ></td>
          <td rowspan="3" valign="top"> <div align="left" class="txtred"><u>&nbsp;&nbsp;Current events&nbsp;&nbsp;</u></div><br>
		  <div align="left" class="resultdisplay">
		  <? if($myrow['offer_discounts']=="")
		  {
			echo "Not Available";
		  }
		  else
		  {
		  ?>

		  <?
		  $var1=trim($myrow['offer_discounts']);
		  $text1=wordwrap($var1, 30, "<br />\n",1);
		  echo ($text1);
		  }
		  ?>
		  </div>
		  </td>
          <td>&nbsp;</td>
          <td rowspan="3" valign="middle" width="9%"><div align="left">
            <input type="button" value="More Info" OnClick="javascript:loadPage('listing_details.php?id=<? echo trim($myrow['directory_id']);?>&nolistings=<? echo $total[0]; ?>&<? echo $navurl;?>')" style="cursor:hand">
          </div></td>
        </tr>


<tr>
              <td rowspan="2" valign="top"><div align="left" class="searchhdng">Address:&nbsp;</div></td>
              <td rowspan="2" valign="top"><div align="left" class="resultdisplay">
			  <? if($myrow['Address_profession']=="")
			  {
				echo "Not Available";
			  }
			  else
			  {
			   $var=trim($myrow['Address_profession']);
			   $text=wordwrap($var, 25, "<br />\n",1);
			   echo ($text);
			  }
			  ?>

		  </div></td>
          <td width="6%" valign="top"><div align="left" class="searchhdng">Fax:</div></td>
          <td width="11%" valign="top"><div align="left" class="resultdisplay">
		  <? if($myrow['fax']=="")
		  {
			echo "Not Available";
		  }
		  else
		  {
		   echo trim($myrow['fax']);
		  }
		  ?>
          <br>
		  </div></td>
          <td width="5%" rowspan="2" valign="top"><div align="left" class="searchhdng">Email:</div></td>
          <td width="18%" rowspan="2" valign="top"><div align="left" class="resultdisplay">
		   <? if($myrow['email_address']=="")
		  {
			echo "Not Available";
		  }
		  else
		  {
		  	if($myrow['dispemail']=="no")
			{
			?>
			<a href="mailto: <? echo trim($myrow['email_address']); ?>"><? echo trim($myrow['email_address']); ?></a>
			<?
			}
			else
			{
			?>
			<input type=button value='Send Email' OnClick="javascript:loadPage1('sendemail.php?mid=<? echo $myrow['directory_id'];?>','1')" style="cursor:hand">
			<?
			}

		  }
		  ?>
		  </div></td>
          <td rowspan="2">&nbsp;</td>
        </tr>
        <tr>
          <td valign="top"><div align="left" class="searchhdng">Website: </div></td>
          <td width="11%" valign="top"><div align="left" class="resultdisplay"> <? if($myrow['websitename ']=="")
		  {
			echo " Not Available";
		  }
		  else
		  {
		  ?>
		   <a href="<? echo trim($myrow['websitename']);?>" target="_blank"><? echo trim($myrow['websitename']);?></a>
		   <?
		  }
		  ?>
            </div></td>
        </tr>
		<tr>
          <td colspan="14" height="10"></td>
          </tr>
		  <tr>
          <td colspan="14">&nbsp;</td>
          </tr>

      </table>
	  </td>
    </tr>
	<tr>
      <td height="10" colspan="3" valign="top"> </td>
    </tr>
		<?

			}
			}


		 ?>


  </table>
  </form>


          <br>
          </div></td>
<td width="15"></td>
  </tr>
  <tr>
    <td colspan="3"><? include ("footer.php") ?></td>
  </tr>
</table>

</body>
</html>

thread_PHP

Sorry For These Many Posts For One Question I Have Large Code

Weedpacket

Then why not post it in an attachment? Surely you can just attach the PHP file without converting it to RTF first?

Shrike

Also try to highlight where you think the problem might be. I hardly think a recordset pager requires 100s of lines of code.

Weedpacket

Shrike wrote:
Also try to highlight where you think the problem might be.

Right, and like BuzzLY sez:

Try to minimize the amount of code that has to be waded through. Try to remove parts with the aim of reducing the script to the smallest piece of code that still exhibits the problem. As you snip away parts of your code, you may discover what the problem is yourself, and not have to post your question after all!