check if its not in db

[JankaZ]

How ken i make to script chect a song if its nat in db if its is than drop error song alredy exist!

Albums=album

dziesma=song

izpilditajs=artis

And i nide to check if posted song nat in db else post error song alredy posted.

PLZZZ help.

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("top", $con);

$sql="INSERT INTO top (albums, izpilditajs, dziesma)
VALUES
('$_POST[albums]','$_POST[izpilditajs]','$_POST[dziesma]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Paldies tava dziesma ir pievienota.";

mysql_close($con)
?> 

[Lamez]

You can do something like this

$q = mysql_query("SELECT song FROM table WHERE artist = '$artist'");
if(mysql_num_rows($q) == 0){
  echo "Song Exists";
}

 

[JankaZ]

Im nowbie here ken you fix my code and there nide else to i think dat!

 

else

echo song add tnx!