PHP循环运行遍布我的“mysql”表[重复]

Question

This question already has an answer here:

• PHP parse/syntax errors; and how to solve them? 17 answers

Hello, I'm trying to run on 15 rows ONLY! each time.

First, this is my code-

PHP:

<div id ="items">
    <?php
    include './DateBaseLogOn.php';
    $sql = "SELECT * FROM items LIMIT 0, 15";
    $RESULT=$conn->query($sql);
    if(!$conn) {
      die("Connection Failed: ".mysqli_connect_error());
    }
    $row = $RESULT->fetch_assoc();
    while($row = mysqli_fetch_array($RESULT))
    {
    echo "<div id =\"itembox\">";
    echo "<div id=\"itempicture\"><img src=\"getImage.php?id=."$row['id']".\" width=\"230\" height=\"140\" /></div>";
    echo "<div id=\"iteminfo\">"."Info:".$row['info'].
    "</br>"."Current price:".$row['price'].
    "</br>"."Time until expired:".$row['exp'].
    "</br>"."Offer avilable until:".$row['timeleft'].
    "</br>"."Place:".$row['location'].
    "</div>";
    echo "<button class=\"sendprice\" onclick=\"location.href=$link\">Place bid</button>";
    echo "</div>";
    }

My questions are:

1. I'm getting an error :

( ! ) Parse error: syntax error, unexpected '$row' (T_VARIABLE), expecting ',' or ';' in C:\wamp\www\index.php on line 87

If i delete the <img src=\"getImage.php?id=."$row['id']".\" width=\"230\" height=\"140\" />

it works but i need to put the image there...

2. how can i tell the while loop to run only on 15 rows? and how can i make it run on the next 15 row with a click of a button (look at the echo row before the last echo row).

</div>

Answer 1

echo "<div id=\"itempicture\"><img src=\"getImage.php?id=."$row['id']".\" width=\"230\" height=\"140\" /></div>";

You have the . after and before $row, inside the quotes. They need to be outside of the quotes.

EDIT:

So the solution is:

echo "<div id=\"itempicture\"><img src=\"getImage.php?id=".$row['id']."\" width=\"230\" height=\"140\" /></div>";