[PHP] doubt regarding mysql php

Hi dearest friend, can we update the same row immediately after selection. please see the following code at line number 29 it is giving error. code ?php // Connect to MySQL $connection = mysql_connect( 'localhost', 'balaji', 'pingpong' ) or die

Re: [PHP] doubt regarding mysql php

Line 29: $sql2=UPDATE inventory SET inv_status=assigned where inv_tag='$inv_tag' ; will give a php error - it should read either $sql2=UPDATE inventory SET inv_status='assigned' where inv_tag='$inv_tag' ; or $sql2=UPDATE inventory SET inv_status=\assigned\ where