edit record in mysql and receive error
| From: | Manu Verhaegen | Date: | Wed, 20 Mar 2002 13:16:06 +0000 |
| Subject: | edit record in mysql and receive error | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-89321@lists.php.net to get a copy of this message | ||
Hi,
I have the following records in my table dnsDNS
Record 1 :
Login = company1
ip = 10.123.100.111
Record 2 :
Login = company2
ip = 10.123.101.111
I want to update recordnumber 1
I receive error
<?php
$ip="10.10.9.100";
$company="company1";
$host="localhost";
$user="username";
$password="abcdef";
$database="database1";
$query = "update dynDNS SET IP='$ip' where Login='$company'";
mysql_connect ($host, $user, $password);
mysql_select_db($database);
$result=mysql_query($query);
if ($result == 0) {
echo("error");
echo("<BR>");
}
?>