NEED HELP WITH ADDING A NUMBER TO A IMAGE...

[Techmate]

This should be super simple for you guys . Mysql in my table are columns id, name, image, position.

 

Here is all I need in the position column I need the position to be in numerical order when an image is uploaded. Can someone give me a code line to do that?

 

 

[teynon]

You could select the highest number, then increase it by one.

 

$sql="SELECT position FROM table ORDER BY position DESC LIMIT 0, 1";
if ($query=@mysql_query($sql)) {
   $position = 1;
   if (mysql_num_rows($query) > 0) {
      $position = mysql_result($query, 0, 0) + 1;
  }
}
else {
   echo "Error: ".mysql_error();
}

 

[phpSensei]

edit: I misunderstood.

[Techmate]

You could select the highest number, then increase it by one.

 

$sql="SELECT position FROM table ORDER BY position DESC LIMIT 0, 1";
if ($query=@mysql_query($sql)) {
   $position = 1;
   if (mysql_num_rows($query) > 0) {
      $position = mysql_result($query, 0, 0) + 1;
  }
}
else {
   echo "Error: ".mysql_error();
}

 

Your awesome, but. As soon as I posted that I figured it out...lol.

I ended up going with:

 

//Querys the last postion in the colum

$result = mysql_query ("SELECT column FROM table ORDER BY column DESC LIMIT 0,1");

// 
while($row = mysql_fetch_array($result)){

$column = $row['column'];

}

echo ++$name;