Not Updateing

[Anon]

ok here is my script:

#!/usr/local/bin/php
<?php

$server = "unixsql3.interland.net";
$user = "Mort";
$password = "Candy";

$db = mysql_connect($server,$user,$password);

mysql_select_db("IdiotBoxTV",$db);

$sql = "update [LOW_PRIORITY] guest SET datenow = '$date', name = '$name', email = '$email', url = '$url', details = '$details', where id = '$No'";

$result = mysql_query($sql);
?>

i dont know why it is not updating my script. everything seems to be in order. note: i am using this in conjunction with flash to update a guestbook

[Anon]

Does your code actually have a comma after details = '$details'? and before the where clause. If so then that is one problem. You should print out your SQL statement after creating it so that you can make sure it looks right. Also you should always check for errors after you run a query.