Re: Query not working on php, but does work in workbench

[Peter Brawley]

Use the nysqli API. The mysql API is deprecated and will be removed.

All calls that can throw errors need error handling---at a bare minimum, something like ...

$conn = mysqli_connect($host,$user,$password,$db) or exit( mysqli_connect_error() );
...
$res = mysqli_query($conn,$sql) or exit( mysqli_error($conn) );

If the result diff persists after you make those changes, add ...

echo $sql;

before the mysqli_query() call, and paste the runtime result it displays back into WorkBench.