why is it inserting into middle?

Verd

HI!

Whenever I insert a row into a table, it doesnt put it at the end. It always puts it somewhere in the middle. Here's my code...

include("0ADBConnect.php");

$query = "SELECT * FROM news";
$newsdb = mysql_query($query);

$rows = mysql_numrows($newsdb);
$newslinknumber = $rows;

$date = date("h").":".date("i").":".date("s")." on ".date("m").'-'.date("d").'-'.date("Y");
$date10 = date("m").'-'.date("d").'-'.date("Y");
$subject = $_POST['subject'];
$news = stripslashes(nl2br($_POST['news']));
$name = $_POST['username'];
$id = $newslinknumber + 1;
$link = "<a href=02News.php#$id>$subject</a><br>";
$log .= "Defined all values to go into the database...<br>";

$query = "INSERT INTO news VALUES ('$subject', '$news', '$name', '$date', '$date10', '$id', '$link')";
mysql_query($query);

mysql_close();

why is it inserting it in the middle?

YappyDog

What makes you think it is inserting it into the middle?

MarkR

Data in relational databases is not usually ordered; the server can rearrange it any way it wants.

Sometimes it might come out in the same order it went in, this is more by luck than judgement.

No application should assume what order things come out as. If you want your data sorted, use "order by".

Mark

mourisj

If you use an auto-incremented ID, you will notice that this ID will be incremented as expected. However, if you do select * from tablename, the rows are not supposed to be displayed in some particular order!

The rows will be there in a possibly ununderstandable order, unless you specify "order by autoincrement_id
This is because your DBMS manages the storage of the data following internal rules (e.g. filling up freed space, ...) ; when selcting the data, it takes them as they are stored on the file-system and processes the ordering afterwards, if you explicitely ask for this. Otherwise, it outputs the data as it finds them.

Have a nice day,

JJ Mouris