An easy mysql check.

[Snooble]

	<?php
$sql = "SELECT * FROM songs WHERE Title = '".$_POST['songtitledelete']."' LIMIT 1";
	mysql_query($sql) or die ("Couldn't execute $sql: " . mysql_error()); 
		if (mysql_query($sql) == NULL){
	echo "No such song";
		} else {
	$sql2 = "DELETE FROM songs WHERE Title = '".$_POST['songtitledelete']."' LIMIT 1";
	mysql_query($sql2) or die ("Couldn't execute $sql: " . mysql_error()); 
		}
?>

 

That should make sense? I want to check if the song is there. Otherwise it always says "Song Deleted". I want something to detect whether it's there before deleting the row.

 

When i run it now i dont see "No such song" when i enter an invalid song name..

 

Thanks

 

Snooble

[papaface]

You should use mysql_num_rows instead.

[Snooble]

an example?? I assume, record the result before the sql and then after and if it's different then say successful else say "no song"?

 

Snooble

[pocobueno1388]

<?php

$sql = mysql_query("SELECT * FROM songs WHERE Title = '".$_POST['songtitledelete']."'");

if (mysql_num_rows($sql) <= 0){
   echo "No such song.";
} else {
   mysql_query("DELETE FROM songs WHERE Title = '".$_POST['songtitledelete']."'");
   
   echo "Successfully deleted song!";
}

?>

 

 

[Snooble]

i see, thank you!

 

Very useful for me