Help increment field

[rondog]

I have a position field and when I upload a file, I need the position of that item to be +1 higher than its previous. I cant use auto increment on this field. I am doing this right now and it putting all uploaded files at 1:

<?php
$sql = mysql_query("INSERT INTO projectData (proj_id,position,type,path,title,description) VALUES ('$projID',position+1,'$type','$fname','$title','$description')") or die(mysql_error());
?>

 

any ideas?

[mikesta707]

the select max mysql command should help you. just do a query, something like

$query = mysql_query("SELECT MAX(position) AS position FROM projectData");
$row = mysql_fetch_assoc($query);
$pos = $row['position'] + 1;

 

than use that pos variable as the value to input into your position column. You may want to check my syntax first tho

[rondog]

Is that really the only way? I have to do a whole other query to increment it?

[Ken2k7]

INSERT INTO projectData (`proj_id`,`position`,`type`,`path`,`title`,`description`) VALUES ('$projID',`position`+1,'$type','$fname','$title','$description')

 

Does that work?

[Daniel0]

Why can't you use auto increment?

[rondog]

Why can't you use auto increment?

 

Because I have an id field already that is auto increment. My table is called projectData

 

It contains data for more than one project so there can be fields that look like:

id

proj_id

position

111

212

313

421

522

623

724

 

so that is why auto increment wont work

[Ken2k7]

But if you just use position  + 1, it will work exactly like AUTO_INCREMENT. How did you get the 1 after the 3?

[rondog]

right ken..I just thought about that..I am going to have to use mikesta's suggestions with a little modification

 

<?php
$query = mysql_query("SELECT MAX(position) AS position FROM projectData WHERE proj_id = '$projID'");
$row = mysql_fetch_assoc($query);
$pos = $row['position'] + 1;
?>