回应表的最后两列

I have a table and i want to echo the 2 last rows of my tabel, I used the below code but just the last one showed, what is the problem.

$result1 =(mysql_fetch_array(mysql_query("SELECT * FROM $table ORDER BY id DESC LIMIT 2")));

Print $result1['time'];

For 2 Or more rows you need to loop it

$sql = mysql_query("SELECT * FROM $table ORDER BY id DESC LIMIT 2")

while($row=mysql_fetch_array($sql))
{
    echo $row['time']."<br>";
}

My solution:

$limit = 2;

$sql = "SELECT * FROM $table ORDER BY id DESC LIMIT $limit";
$result = mysql_query($sql);

$array = array(); $i = 0;
while($row = mysqli_fetch_array($result))
{
    $array[$i] = $row;
    $i++;
}

var_dump($array[0]);
var_dump($array[1]);

mysql_fetch_array = 1 fetch.

do it again for fetching 2nd result.

Also, use mysqli eh.

You're doing mysql_fetch_array only one time, so it gets the first element. If you want to get all the elements, then do it again, or use a loop.

Something like:

$query = "SELECT * FROM $table ORDER BY id DESC LIMIT 2";

while($row = mysql_fetch_array(mysql_query($query) )
{
    echo $row['time'].'<br>'; 
}

$query = mysqli_query("SELECT * FROM $table ORDER BY id DESC LIMIT 2");
while ($result = mysqli_fetch_array($query)) {
    echo $result['time'];
}

Gives out every return of your database (2 in this case). You should use mysqli_-functions.

Maybe you should try like this, since mysql_fetch_array returns only one row

while ($row = mysql_fetch_array($yourQuery)) {
    echo $row["yourAlias"];
}

Further details here : http://fr2.php.net/manual/en/function.mysql-fetch-array.php