[Resolved] Form sends data to TOP or table. Dont want that.

fr8

Ive added a comment system to my site so my members can leave comments about the page they are on.

My problem is im not sure why the form is sending the data to the TOP of the table in the database. Every other form/table i have in mysql the data is sent to the bottom.

Any ideas?

My form:

<FORM action=\"guest.php?menulink=View&pid=".$pid."&Comment=Add \" method=POST>
<input type=\"hidden\" name=\"name\" value=\" ". $_SESSION['username'] ."\"><BR>
<input type=\"hidden\" name=\"date\" value=\" ". date( 'Y-m-d H:i:s' )."\">
Poster: ". $_SESSION['username'] ."<BR>:: 250 Characters Max ::<BR>
<TEXTAREA cols=\"40\" rows=\"5\" name=\"comment\"></TEXTAREA><BR>
<input type=\"submit\" name=\"submit\" value=\"Add Comment\"
</FORM>

The insert:

$query = "INSERT INTO js_content_comments VALUES('',$pid,'{$_POST['name']}', '{$_POST['comment']}', '{$_POST['date']}')";
    mysql_query($query);

My table:

id int(10) unsigned NOT NULL auto_increment,
   news_id int(10) unsigned DEFAULT '0' NOT NULL,
   name varchar(40) NOT NULL,
   comment text NOT NULL,
   PRIMARY KEY (id)

okuto1973

Sending data to the TP of the table???What do you mean?

fr8

Every time new data is added to the table in the database it goes to the top.

instead of the auto increment saying
1
2
3
it goes
3
2
1
Every table that i have it goes down the correct way. But this is different. Dont know why.

Weedpacket

It shouldn't matter: which row in a table that a record appears is considered in database design to be irrelevant to users; it should be possible to rearrange them at will without changing the results of any queries. You've got a news_id field so you can just ORDER BY that.

fr8

Originally posted by Weedpacket
It shouldn't matter: which row in a table that a record appears is considered in database design to be irrelevant to users; it should be possible to rearrange them at will without changing the results of any queries. You've got a news_id field so you can just ORDER BY that.

That was the remedy that I added while I was trying to figure out why this was occuring. The only reason I cared is that I have to sort the items now and it takes up more processing time. If im incorrect in saying this please correct me and then I wont have to worry about this problem. 😃

LordShryku

You won't notice the processing time it takes to sort these records, unless you're pulling millions of records. In which case, it's going to take a while anyway, and you probably shouldn't be using PHP for that.

ORDER BY is a standard in SQL simply for the fact that databases are made to be manipulated. It's just not possible to keep shifting data in the database every time something is inserted/deleted/updated....

fr8

well i know i wont have millions of entrys for a long long time. thanks for the input. now i dont have to worry about it. as long as i sort the query im fine. thanks for the input everyone.