Update not successfull : why ??

I am able to successfully run sqlsrv SELECT querys, but my UPDATE is returning false.

Here's what I've got:

$stockPN='TEST ITEM 2';
$newDesc='UPDATE SUCCESSFUL';
$updateSQL="UPDATE partrecord SET description=\'$newDesc\' WHERE fullpartnumber=\'$stockPN\' AND quantity>0";
$update=sqlsrv_query($rzConn,$updateSQL);
echo '<pre>';
var_dump($update);
echo '</pre>';


Am I doing something wrong ?
~ Mo

try;


$updateSQL="UPDATE partrecord SET description='" . $newDesc . "' WHERE fullpartnumber='" . $stockPN . "' AND quantity > 0";

Thanks !
That did it !!
But ... why?
Aren't those two options basically the same ??

~ Mo

no, $newDesc is a string and should be wrapped in quotes, however you escaped the quotes which was causing the update to fail.