Jump to content

[SOLVED] Having a strange problem


swanley007

Recommended Posts

Here is the code...It seems to be working, but the database is not updating.    ???

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
$username = "------";   Actually filled in
$password = "------";   Actually filled in
$database = "efront_bugs";
$ans = $_GET['ans'];
if ($ans == YES){
$ans2 = 1;
}
else{
$ans2 = 0;
}

$numb = $_GET['numb'];
$query = "UPDATE bugs SET Solved = ". intval($ans2)." WHERE Number = ". intval($numb) . " LIMIT 1";
$link = mysql_connect(localhost,$username,$password);
@mysql_select_db($database, $link) or die( "Unable to select database");
$result  = mysql_query($query, $link)or die ("Unable to Change Data");
mysql_close();
echo $ans . "<br>";
echo $ans2 . "<br>";
echo $query . "<br>";
echo mysql_errno($link) . ": " . mysql_error($link) . "\n";

?>
<META HTTP-EQUIV=REFRESH CONTENT="5; URL=../index.php">
</body>
</html>

 

The output is as follows:

 

NO

0

UPDATE bugs SET Solved = 0 WHERE Number = 1 LIMIT 1

0:

Link to comment
https://forums.phpfreaks.com/topic/133226-solved-having-a-strange-problem/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.