1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
|
<?php
include"connex.php";
mysql_select_db ($mabasededonnee, $connection) ;
//recup des var
$id=$_GET["id"];
$ordre=$_GET["ordre"];
$new1=($ordre+1);
//
$sel="SELECT * FROM photo WHERE ordre='$ordre'";
$req1 = mysql_query($sel) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
$data = mysql_fetch_array($req1);
$id1=$data['id'];
$titre1=$data['titre'];
$description1=$data['description'];
$image1=$data['image'];
$ordre1=$data['ordre'];
$etat1=$data['etat'];
$mini1=$data['mini'];
mysql_free_result ($req1);
$sel2="SELECT * FROM photo WHERE ordre='$new1'";
$req2 = mysql_query($sel2) or die('Erreur SQL !<br />'.$sel2.'<br />'.mysql_error());
$data2 = mysql_fetch_array($req2);
$id2=$data2['id'];
$titre2=$data2['titre'];
$description2=$data2['description'];
$image2=$data2['image'];
$ordre2=$data2['ordre'];
$etat2=$data2['etat'];
$mini2=$data['mini'];
mysql_free_result ($req2);
//suppression
$sup1 ="DELETE from photo WHERE ordre='$ordre'";
mysql_query($sup1) or die('Erreur SQL !<br />'.$sup1.'<br />'.mysql_error());
$sup2 ="DELETE from photo WHERE ordre='$new1'";
mysql_query($sup2) or die('Erreur SQL !<br />'.$sup2.'<br />'.mysql_error());
//insertion
$ins1="INSERT INTO photo (titre, description, image, ordre, etat, mini) VALUES('$titre1','$description1','$image1','$new1','$etat1', '$mini1')";
// requete
mysql_query($ins1) or die('Erreur SQL !<br />'.$ins1.'<br />'.mysql_error());
$ins2="INSERT INTO photo (titre, description, image, ordre, etat, mini) VALUES('$titre2','$description2','$image2','$ordre1','$etat2', '$mini2')";
// requete
mysql_query($ins2) or die('Erreur SQL !<br />'.$ins2.'<br />'.mysql_error());
mysql_close ();
?> |
Partager