Re: jquery update database

[Peter Brawley]

The mysql API is deprecated. Use mysqli.

To see the actual query ...

$qry = "SELECT * FROM house WHERE id = $id";
echo $qry;

.. and paste what displays into the mysql client to debug.

> $id = trim($_REQUEST['name']);

Always run such input through mysqli_real_escape_string.

You always need to poll for errors in any function call that can fail, ie

$conn = mysqli_connect(...) or exit( mysqli_connect_error() );

...mysqli_query(...) or exit( mysqli_error($conn) );