为什么这个SQL查询不起作用？

Question

this script have to update things on every refresh but not working. lend me a hand

$yp = mysql_query("select id from yyy where twitterid = '$tid'");

$qq = "update yyy set twitterid = '$tid', 
twitterkullanici = '$twk', 
tweetsayisi = '$tws', 
takipettigi = '$tkpettigi', 
takipeden = '$tkpeden', 
nerden = '$nerden', 
bio = '" . mysql_real_escape_string($bio) . "', 
profilresmi ='$img', 
ismi = '$isim' 
where id = '$yp'";
$xx = mysql_query($qq);

Answer 1

Looks like you are not getting the value out of the variable $yp.

You need to do

$row = mysql_fetch_row($yp);

then

id = '.$row[0] .'

in your update query