[SOLVED] Delete Row

[fesan]

Hello...

 

Can't find the error in this script.

Can anyone help me?

 

<?php

$user_name1 = !empty($_POST ['user_name1']) ? $_POST['user_name1'] : '';
$user_name2 = !empty($_POST ['user_name2']) ? $_POST['user_name2'] : '';

if($user_name1 == $user_name2){ //checks and sets the username to delete
$correct_username = $user_name1;
include("conn/conn_usr.php"); // includes the DB connection
$check_username = "SELECT * FROM $dbtable WHERE brukernavn = '$correct_username'";
$result = mysql_query($check_username) or die(mysql_error());
if(mysql_num_rows($result) > 0) { // [b]This is where it fails!![/b]
	die("Det er ingen bruker med angitt brukernavn,<br>".
	"<p>Prøv et annet navn.</p>");		
} else {
	$query_del = "DELETE FROM $dbtable WHERE brukernavn = '$correct_username'";
	mysql_query($query_del) or die(mysql_error());
}
} else {
echo "Du har tastet 2 forskjellige brukernavn"; // the two username variables are different
}

?>

 

The variables user_name1, user_name2 and correct_username all return the correct and same value...

 

Thanks!

 

[Yesideez]

Try this:

      $query_del = "DELETE FROM $dbtable WHERE brukernavn = '$correct_username'";
      echo 'QUERY='.$query_del;

 

Post back what it shows.

[Maq]

That's because it should die.

 

This line means that the user name exists.  I think you want '==0' here.  And the else would mean that the username exists, so delete it.

 

   if(mysql_num_rows($result) > 0) {

[fesan]

Great!!

 

All I needed was to change from

if(mysql_num_rows($result) > 0) {

 

to

 

if(mysql_num_rows($result) == 0) {

 

thank you!!!