update sorting

Snib · September 18th, 2004, 06:43 PM

When I say missing quotes, this...

$query1="UPDATE jackbecky SET sequence = ".$newsequence." WHERE id = ".$id;

...should be this:

$query1="UPDATE jackbecky SET sequence='".$newsequence."' WHERE id = '".$id."'";

But regardless of what I think, the hint I gave you should be enough to help you solve the problem.

HTH,

-Snib <><
http://www.snibworks.com
There are only two stupid questions: the one you don't ask, and the one you ask more than once :-)

dkittell · September 18th, 2004, 09:29 PM

Working Example:

Code:

<?PHP 
if ($sequence > $newsequence) 
{ 
   $link = mysql_connect("localhost","dbuser","dbpass"); 
   mysql_select_db("db",$link); 

   $query2="UPDATE jackbecky SET sequence='1000' WHERE id = ".$id.""; 
   mysql_query($query2) or die(mysql_error()); 

   $query1="UPDATE jackbecky SET sequence = ( sequence +1 ) WHERE sequence >=".$newsequence." AND sequence <=".$sequence.""; 
   mysql_query($query1) or die(mysql_error()); 

   $query1="UPDATE jackbecky SET sequence = ".$newsequence." WHERE id = ".$id.""; 
   mysql_query($query1) or die(mysql_error()); 

} 
if ($sequence < $newsequence) 
{ 
   $link = mysql_connect("localhost","dbuser","dbpass"); 
   mysql_select_db("db",$link); 

   $query2="UPDATE jackbecky SET sequence='1000' WHERE id = ".$id.""; 
   mysql_query($query2) or die(mysql_error()); 

   $query1="UPDATE jackbecky SET sequence = ( sequence -1 ) WHERE sequence <=".$newsequence." AND sequence >=".$sequence.""; 
   mysql_query($query1) or die(mysql_error()); 

   $query1="UPDATE jackbecky SET sequence = ".$newsequence." WHERE id = ".$id.""; 
   mysql_query($query1) or die(mysql_error()); 
} 

header("location:index.php") 
?>

---
David Kittell