swanley007 Posted November 18, 2008 Share Posted November 18, 2008 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: Quote Link to comment https://forums.phpfreaks.com/topic/133226-solved-having-a-strange-problem/ Share on other sites More sharing options...
swanley007 Posted November 18, 2008 Author Share Posted November 18, 2008 I am an idiot... I was passing the row not the primary key. This was allowing the code to run without error, but there was no record to update. Stupid me! Quote Link to comment https://forums.phpfreaks.com/topic/133226-solved-having-a-strange-problem/#findComment-692886 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.