Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if($action == "FullDelete")
- {
- $query = "DELETE FROM beschreibungen
- WHERE ID IN (SELECT ID_beschreibungen_old
- FROM crosstable
- WHERE ID = ".$id")";
- $result = mysql_query($query);
- if (!$result)
- {
- die('Ungueltige Abfrage: ' . $query);
- }
- else
- {
- echo 'bla bla4-1';
- }
- $getID = "SELECT ID_abkuerzungen_old
- FROM crosstable
- WHERE ID = ".$id;
- $query1 = "SELECT a.ID, a.abkuerzung
- FROM abkuerzungen a
- JOIN beschreibungen b
- ON a.ID=b.ID_Abkuerzung
- WHERE a.ID = ".$getID;
- $result = mysql_query($query1);
- if (!$result)
- {
- die('Ungueltige Abfrage: ' . $query1);
- }
- else
- {
- echo 'bla bla4-2';
- if(mysql_num_rows($result)==0)
- {
- mysql_query(DELETE FROM abkuerzungen WHERE ID = $getID);
- echo 'bla bla4-2-1';
- }
- }
- $query2 = "DELETE FROM crosstable WHERE ID = ".$id;
- $result = mysql_query($query2);
- if (!$result)
- {
- die('Ungueltige Abfrage: ' . $query2);
- }
- else
- {
- echo 'bla bla4-3';
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement