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

?>

Are your $_GET variables being populated?

Have you tested the query in PHPMyAdmin with actual values to make sure it is working?

Your filename=$f has no quotes around the $f.

pixie said the error, the f needs quotes you can only use no quotes for number fields and you should get it to tell you why it's erroring it will likely give error in mysql query at point where it says filename = $f

//change $k=mysql_query($query,$con); to below
if(mysql_query($query,$con)){
echo 'inserted';
}else{
echo 'failed->'.mysql_error($con);
}
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.