|
|
Posted by ZafT on 10/31/39 11:55
>
> have you tried running mysql_error() after the update's. You may have a
> single quote/apostrophy in $name, $description, or $show that needs to
> be escaped before the string can be used in the query. I'm not sure
> what the escape character is in MySQL, but in SQL Server you just have
> to double the single quotes to have the dbms treat it as part of the
> string instead of the end of the string.
>
> Josh
>
I tried this:
$link = mysql_connect($dbserver,$username,$password)
or die( "Unable to connect");
<snip .....>
$query="UPDATE project SET name='$name',
description='$description',
show='$show'
WHERE id=$id";
mysql_query($query);
mysql_error($link);
No errors. Is that what you meant?
Shane
Navigation:
[Reply to this message]
|