mysql_query 'undtagen hvis" funktion?

if($dvd > 0) { UPDATE mdb SET loan='$loan', loandate='$loandate' WHERE dvd='$dvd' } else { UPDATE mdb SET loan='$loan', loandate='$loandate' WHERE dvd='0' }

?

Hvordan får jeg den integreret i den her? Jeg er n00b i PHP så er ikke helt sikker:

+++++ START +++++
<?php

if ($submit) {

include 'connect.php';


$id=            $_GET['id'];
$title1=        $_GET['title1'];
$title2=        $_GET['title2'];
$cover=            $_GET['cover'];
$year=            $_GET['year'];
$disc=            $_GET['disc'];
$videoquality=    $_GET['videoquality'];
$location=        $_GET['location'];
$language1=        $_GET['language1'];
$language2=        $_GET['language2'];
$langsep1=        $_GET['langsep1'];
$subtitle1=        $_GET['subtitle1'];
$subtitle2=        $_GET['subtitle2'];
$subsep1=        $_GET['subsep1'];
$loan=            $_GET['loan'];
$actor=            $_GET['actor'];
$type=            $_GET['type'];
$dvd=            $_GET['dvd'];
$audioquality=    $_GET['audioquality'];
$loandate=        $_GET['loandate'];
$persrating=    $_GET['persrating'];
$language3=        $_GET['language3'];
$langsep2=        $_GET['langsep2'];
$subtitle3=        $_GET['subtitle3'];
$subsep2=        $_GET['subsep2'];

$query="UPDATE mdb SET dvd='$dvd', title1='$title1', title2='$title2', cover='$cover', year='$year', disc='$disc', videoquality='$videoquality', location='$location', language1='$language1', language2='$language2', langsep1='$langsep1', subtitle1='$subtitle1', subtitle2='$subtitle2', subsep1='$subsep1', loan='$loan', actor='$actor', type='$type', audioquality='$audioquality', loandate='$loandate', persrating='$persrating', language3='$language3', langsep2='$langsep2', subtitle3='$subtitle3', subsep2='$subsep2' WHERE id='$id'";
if(mysql_query($query))
{

    echo "opdateret";
}


else {



    echo "Ikke opdateret";

    }

mysql_close();
}
  ?>
+++++ SLUT +++++

Tak til talker samt point :D

Koden som virker:

++++++++++++++++
<?php

if ($submit) {

include 'connect.php';


$id=            $_POST['id'];
$title1=        $_POST['title1'];
$title2=        $_POST['title2'];
$cover=            $_POST['cover'];
$year=            $_POST['year'];
$disc=            $_POST['disc'];
$videoquality=    $_POST['videoquality'];
$location=        $_POST['location'];
$language1=        $_POST['language1'];
$language2=        $_POST['language2'];
$langsep1=        $_POST['langsep1'];
$subtitle1=        $_POST['subtitle1'];
$subtitle2=        $_POST['subtitle2'];
$subsep1=        $_POST['subsep1'];
$loan=            $_POST['loan'];
$actor=            $_POST['actor'];
$type=            $_POST['type'];
$dvd=            $_POST['dvd'];
$audioquality=    $_POST['audioquality'];
$loandate=        $_POST['loandate'];
$persrating=    $_POST['persrating'];
$language3=        $_POST['language3'];
$langsep2=        $_POST['langsep2'];
$subtitle3=        $_POST['subtitle3'];
$subsep2=        $_POST['subsep2'];

$query1="UPDATE mdb SET loan='$loan', loandate='$loandate' WHERE dvd='$dvd'";
$query2="UPDATE mdb SET loan='$loan', loandate='$loandate' WHERE id='$id'";

if($dvd > 0) {mysql_query($query1);} else {mysql_query($query2);}

$query="UPDATE mdb SET dvd='$dvd', title1='$title1', title2='$title2', cover='$cover', year='$year', disc='$disc', videoquality='$videoquality', location='$location', language1='$language1', language2='$language2', langsep1='$langsep1', subtitle1='$subtitle1', subtitle2='$subtitle2', subsep1='$subsep1', actor='$actor', type='$type', audioquality='$audioquality', persrating='$persrating', language3='$language3', langsep2='$langsep2', subtitle3='$subtitle3', subsep2='$subsep2' WHERE id='$id'";
if(mysql_query($query))
{

    echo "opdateret";
}


else {



    echo "Ikke opdateret";

    }

mysql_close();
}
  ?>
+++++++++++++++

Np :) Du skriver bare hvis du for problemer med det.