Finding Lowest Number

[swamp]

Hey,

 

I've got a field called position, the default is currently 1. You can change the position using up + down form controls.

 

Whem I submit a new row to the database through a form I want the field position to default to the lowest current position and be one less than that...

 

Eg

 

<input type="hidden" value=<?php echo $lowest_position - 1 ?>">

 

and:

 

$lowest_position - LOWEST CURRENT POSITION - 1;

 

 

[DarkWater]

INSERT INTO table (something, name, position) VALUES ('testing!', 'DarkWater', MIN(position) - 1);

 

Yeah.