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: 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! 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
Archived
This topic is now archived and is closed to further replies.