simple query solve it and give me the query [closed]
- by Dharmendra
table is : nobel(yr, subject, winner)
Query is : In which years was the physics prize awrded but no chemistry prize.
here 'winner' is the name of winner
please solve
This is my query
$id contains primary key and $status contains new status
public function updateStatus($id,$status)
{
$qb=$this-createQueryBuilder('b')
-update()
-set('b.status',$status)
-where('b.id='.$id);
echo $qb;
return $qb-getQuery()
…
