Kāds zina kāds sql order by kods ir jāliek pie query,lai jaunākais ieraksts izvadās augšpusē.
<html>
<head><title>čats</title></head>
<body>
<h1>Čats</h1>
Tavs teksts : <br>
<form action="cats.php" method="post">
<textarea rows="5" COLS="50" NAME="teksts">
</textarea><br>
<input type="submit" value="Ievietot">
</form>
</body>
</html>
<?php
if(isset($_POST['teksts'])&& $_POST['teksts']!==""){
$teksts=$_POST['teksts'];
mysql_connect("localhost","root","");
@mysql_select_db("cats");
$query = "INSERT INTO izvade VALUES (NULL, '$teksts')";
mysql_query($query);
}
else{
$_POST['teksts']="";
}
mysql_connect("localhost","root","");
@mysql_select_db("cats");
$query = "select * from izvade ORDER BY id";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo $row['teksts'],"<br>";
}
?>
