update query not working

[shubh2488]

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....i am attaching the output jpeg image.

 

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";
     
    ?>

 

MOD EDIT: Changed PHP manual tags to code tags.

 

[attachment deleted by admin]

[Pikachu2000]

Do you see something missing around the filename?

[shubh2488]

nope....

 

firstly i tried updating these data with filename in where clause,dat was not working so i tried with unique_id in where clause....?

 

wat to do ?

[Pikachu2000]

String values should be quoted in the query string.