PHP - Moved: Displaying Only Subpages Of Parent Pages - Wp ?! Need Help!

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=356195.0

This topic has been moved to HTML Help.

http://www.phpfreaks.com/forums/index.php?topic=352551.0

Hello Everyone was wondering if I could get some help with the following code? I am querying a database for results of listings that are in a database these listings are displayed on the page in a form. I am wanting each listing to be on a different page. Below is my code.
Code: [Select]


$lim=1;
if (!isset($s) || $s < 1 || !is_numeric($s)) {
            $s = 1;
        }


    $start = ($s - 1) * $lim;
     $sql = "select id,bussimg,imagewidth,imageheight,email,usridm,company,businesscategory,address1,address2,state,city,zip,website,email,repname,description,phonenumber,country,status from $approvecheckbusinesses where usridm='$user_id'";
    $result=db_query($sql);
     



        $countpages = $sql;
        $sql = $sql . " order by id asc limit $start, $lim";
       $result=db_query($sql);
        $pages = ceil(mysql_num_rows(mysql_query($countpages)) / $lim);
     
   


$result=db_query($sql);
for ($i = 0; $i < mysql_num_rows($result); $i++) {
$Listid= mysql_result($result, $i, "id");

$usridm= mysql_result($result, $i, "usridm");
$CompanyName= mysql_result($result, $i, "company");
$realname= mysql_result($result, $i, "repname");
$email= mysql_result($result, $i, "email");
$BusinessCategory= mysql_result($result, $i, "businesscategory");
$status= mysql_result($result, $i, "status");
   



echo ("FORM IS TO BE DISPLAYED HERE");

}

if ($pages > 1) {
            echo("<p align=left style='font-size: 85% color=white'>");
            for ($i = 1; $i <= $pages; $i++) {
                echo("[");
                if ($i == $s) {echo("<b>");}
                else {echo("<a id=home_offerLink href='index.html?EditMemberListing&user_id=$user_id&s=$i'>");}
                echo("Page $i");
                if ($i == $s) {echo("</b>");}
                else {echo("</a>");}
                echo("]  ");
            }
            echo("</p>")


Page Numbers here using the above code.. The problem I seem to be running into is that it only displats the first record. The page numbers show up page 1 page 3
page 2 and three are blank there is no mysql error or anything for some reason I only get that first result out of three

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=306168.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=346922.0