0

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

?>
Attachments update.jpg 7.36 KB
3
Contributors
2
Replies
3
Views
5 Years
Discussion Span
Last Post by Biiim
1

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.

0

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);
}
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.