Hi guys.. I know little about Programming but I am working with a script and I need to move row 3 (record 3) to the top of the table. What is a command to do this? I have been poking around in myPHPadmin and could not find an easy way to do this.

Thanks for your help :D

Why exactly do you want to do this? You generally don't move rows like that. :)

well I'm using osticket and it appears to order the departments based on the record number. so I want to reorder them now that I am happy with my departments. But I do not want to delete all the rows and start over.

There are 4 records (0-3) and I need to move the last one to the second spot.

Add an order_id attribute, and manually enter the order you want in them.

Then go into osticket and have it ORDER BY `order_id` ASC.

What I would do is make another field (like order_id) and then put the records in order from 0-4 (or however you please) and then when you call the db / records just: ORDER BY by `order_id` ASC

hope it helps (I basically just re-stated DanX's comment..)

OK guys.. slow down a bit.. I'm not too literate in php mysql.

So there already is a column called "ID" and I tried renumbering those with no luck.

Are you familiar with OSticket and would you know where to locate the code to enter this "order by". I would need to know exactly what to put there.

Thanks for your help.. I will try to post the code where the form is. I'm guessing that this is where I would put this code??

Thanks for your help guys :D

Well, Im not 100% familiar with it.. however.. what I'd do is just look for the .php page the dept's show up on... then try to break it down from there.. you should be able to change the ID field.. (I dont know what would stop you?)

ok I found the code on the new ticket form:

<select name="cat">
<?
$cats = mysql_query("SELECT * FROM ticket_categories");
while ($category = mysql_fetch_array($cats)) {
$selected = ($_REQUEST[cat] == $category[ID]) ? " SELECTED": "";
?>
<option value="<?=$category[ID]?>"<?=$selected?>><?=$category[name]?></option>
<?
}
?>
</select>


What would I change it to?

<select name="cat">
<?
$cats = mysql_query("SELECT * FROM ticket_categories ORDER BY id ASC");
while ($category = mysql_fetch_array($cats)) {
$selected = ($_REQUEST[cat] == $category[ID]) ? " SELECTED": "";
?>
<option value="<?=$category[ID]?>"<?=$selected?>><?=$category[name]?></option>
<?
}
?>
</select>


change "id" to whatever it is in your DB..

Sweet it worked... there were only 2 places I could find that listed it so it was not a big change... thanks for your help.. I really appreciate it :D

Not a problem :D