MYSQL DESC LIMIT变量
问题描述:
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
答
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>