retsamedoc

hi keith, thank you for giving me the solution of this problem.. $row=mysql_query("select*from user order by $sort LIMIT 1, 9999999"); works for me.. anyways, thank you for pointing out the $sort clauses. In my page i have a dropdown menu where the user can choose what to sort. thank you again for that.. I'm kinda new to the PHP language and i don't know the common and generic jargons in this language. The variables and the tables, I just made it all up for the sake of practicing PHP.. thank you for the help bro! Skye

Good day! I am new to this forum and a beginner in Php and mysql i have a question my code is working and running.. but i want to have a minor changes.. what will be the correct statement for it to not show a specific row in the table? <?php include('header.inc'); $sort=$_POST['sort']; $row=mysql_query("select*from user order by $sort"); while($show=mysql_fetch_array($row)) { $eno=$show['eno']; echo $show['department']."<br>" ; echo $show['lastname'].", ".$show['firstname']; echo $show['address']."<br>"; echo $show['contactnum']."<br>"; echo $show['date_emp']; } ?> sample table: Department Lastname Address Contact no. Date Employed ! HR John NY 11111 1986-1-11 Finance Paul NY 22222 1986-1-12 IT Div. Ringo NY 33333 1986-1-13 in the example above, I don't want the 1st row to be displayed in the page. thank you guys in advance!