UPDATE confusion

[baffled_in_UK]

Hi,

Can anybody give me a clue why this UPDATE is not updating.

there is a value of BD in the field code in the searchpost table.
the value of $key1 is BD

<?php

... connect stuff....

$sql="UPDATE searchpost SET gone='$gone', start_date=NOW(), end_date='$expdate', idx='$idx', login='$login', pass='$pass' WHERE code='$key1'";

... close stuff...

?>

Thanks

[frog]

Are you using mysql_query ? I.E.

$result=mysql_query($sql);

if(!$result) die("Update Failed");

[baffled_in_UK]

Thanks Frog.

The mysql_query did the trick.