MYSQL DESC LIMIT变量

Question

I try to run this code

$anzahl_neu_ds = $num_rows_after - $num_rows;
    $neue_logs = "SELECT * FROM `logs` WHERE Seitenname = '$val' Order by `Date/Time` DESC LIMIT $anzahl_neu_ds;";
    $ergebnis = mysql_query($neue_logs)
            OR die("Error: $ergebnis <br>".mysql_error());

but i only get 1 result. Is it right how i inserted the $anzahl_neu_ds next to DESC LIMIT? Or how do I insert a Variable inside a Query?

Thanks for helping:

Kind Regards, Kevin

Answer 1

Your only doing a single mysql_query and not fetching the result as an array. Try using the following code:

$anzahl_neu_ds = $num_rows_after - $num_rows;
    $neue_logs = "SELECT * FROM `logs` WHERE Seitenname = '$val' Order by `Date/Time` DESC LIMIT $anzahl_neu_ds";
    while($ergebnis = mysql_fetch_array($neue_logs)){
      echo $ergebnis[0].'<br/>';
    }

</div>