could any one please tell me that, when i call a command to insert value into mysql database, does it insert into the table orderly? what i mean, will the new one placed after the older one? or just insert randomly into the table? or any command i can use to achieve? sorry for my poor english

No, it will be placed at the end of the table.

Can someone tell me why this does not insert into the table...I get no errors, but never get anything inserted into the table!? $hookup = mysql_connect($server, $user, $pass) or die ("Not hooked up to server."); $dbtable=mysql_select_db($db,$hookup) or die ("Not hooked up to database"); $date=($year."-".$month."-".$day); $pdate=($month."/".$day."/".$year); printf("%s%s%s%s%s",$pdate,$id,$auctioneer,$location,$summary); $sql="INSERT INTO auctions (date, auctioneer, descript, region, summary, pdate, location, xlink, ext) VALUES('$date','$auctioneer','$descript','$region', '$summary', '$pdate', '$location', '$xlink', '$ext)"; mysql_query ($sql,$hookup); ?> I appreciate ANY help at all! Thanks tv