this is my php update query ,there are 6 column including album and genere,
3 column value are already inserted in database,in this i just want to update those column value with these two album and genere value..
it's nt getting updated....
please help me....!
<?php
$a=$_GET["artist"];
$g=$_GET["genere"];
$f=$_GET["filename"];
$userid="123456789123456789";
$con = mysql_connect("localhost","root",""); //Update hostname
mysql_select_db("video_upload", $con); //Update database name
$query="UPDATE video
SET album = '$a' , genere = '$g'
WHERE
filename =$f;";
//INSERT INTO video (album,genere) VALUES ('".$a."','".$g."') where unique_id=1" ;
echo "f-----".$query;
echo "<br />";
echo $a;
echo "<br />";
echo $g;
echo "<br />";
echo $f;
echo "<br />";
$k=mysql_query($query,$con);
echo "inserted";
?>