CODEWITHSUNDEEP
php
Bhargav
Bhargav

Reputation: 1

display different image in same div in php

I want to display first image,title and description in col1 div, second in col3 and so on but in this first image repeat in all div . how to solve this

<?php

include('connection.php');
$perPage=1;
$i=1;
if(isset($_REQUEST['act']) && trim($_REQUEST['act']=='load_data')){
     $page=1;
    if(!empty($_GET["page"])) {
$page = $_GET["page"];
}

$start = ($page-1)*$perPage;
if($start < 0) $start = 0;


    $msg='';
    $q="SELECT * FROM addimages  order by id desc limit $start,$perPage  ";
    $res = mysql_query($q);
    $row = mysql_fetch_array($res);
    $id = $row['art_id'];
    $qe="select banner from images where id=$id";
    $rs=mysql_query($qe);
    $name=mysql_fetch_array($rs);
    //$id=$row['id'];
    //$no=mysql_num_rows($res);

    if(!$row==""){

    $msg .= "<div class='article_index' id='".$row["art_id"]."'><div class='article banner_add'><a href='#'><img height='220'  src='./uploads/" . $name['banner'] . "' /></a></div>";

    $msg .="    <div class='post_main' >
            <div class='col1'>
            <div class='post_img'><a href='#'><img class='lazy' data-original='./uploads/" . $row['image'] . "' width='633' height='441' src='./uploads/" . $row['image'] . "' style='display: inline;' /></a>
            </div>
            <div class='post_contant_main'>
            <div class='post_title'><h2><a href='#'>".$row['title']."</a></h2></div>
            <div class='post_contant'>".$row['desc']."</div>
            </div>
            </div>";

    $msg .="        <div class='col3'>
            <div class='post_img'><a href='#'><img class='lazy' width='299' height='191' src='./uploads/" . $row['image'] . "' style='display: inline;' /></a>
            </div>
            <div class='post_contant_main'>
            <div class='post_title post_rtitle'><h2><a href='#'>".$row['title']."</a></h2></div>
            </div>
            </div>
            <div class='col3'>
            <div class='post_img'><a href='#'><img class='lazy' width='299' height='191' src='./uploads/" . $row['image'] . "' style='display: inline;' /></a>
            </div>
            <div class='post_contant_main'>
            <div class='post_title post_rtitle'><h2><a href='#'>".$row['title']."</a></h2></div>
            </div>
            </div>
            <div class='col2'>
            <div class='post_img'><a href='#'><img class='lazy' width='461' height='300' src='./uploads/" . $row['image'] . "' style='display: inline;' /></a>
            </div>
            <div class='post_contant_main'>
            <div class='post_title'><h2><a href='#'>".$row['title']."</a></h2></div>
            <div class='post_contant'>".$row['desc']."</div>
            </div>
            </div>
            <div class='col2'>
            <div class='post_img'><a href='#'><img class='lazy' width='461' height='300' src='./uploads/" . $row['image'] . "' style='display: inline;' /></a>
            </div>
            <div class='post_contant_main'>
            <div class='post_title'><h2><a href='#'>".$row['title']."</a></h2></div>
            <div class='post_contant'>".$row['desc']."</div>
            </div>
            </div>
            </div>
    </div>

    ";
        }

    $msg .="<a class='next' href='#'></a>
        <input type='hidden' id='pageno' name='pageno' value=''>";
    echo $msg;



 }
?>

i want to increase row array to next id and display its content i am using infinite scroll plugin

Upvotes: 0

Views: 66

Answers (1)

Mg Thar
Mg Thar

Reputation: 1102

you fetch only one top row. If you want to get all rows, you need to loop it thought.

while ($row = $result->fetch_row()) {

$msg .="    <div class='post_main' >
            <div class='col1'>
            <div class='post_img'><a href='#'><img class='lazy' data-original='./uploads/" . $row['image'] . "' width='633' height='441' src='./uploads/" . $row['image'] . "' style='display: inline;' /></a>
            </div>
            <div class='post_contant_main'>
            <div class='post_title'><h2><a href='#'>".$row['title']."</a></h2></div>
            <div class='post_contant'>".$row['desc']."</div>
            </div>
            </div>";

}

Upvotes: 1

Related Questions