|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2001-08-18 19:11 UTC] sniper@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Oct 25 03:00:01 2025 UTC |
1 $sq = "SELECT * FROM TLinks WHERE LinkID = 1"; 2 $result = mysql_query($sq) 3 or die ("Error- Could not run Query: $sq!\nError (" . mysql_errno() . ") - " . mysql_error()); 4 5 if ($row = mysql_fetch_array($result)) 6 { 7 $link = $row['Link']; 8 $origins = $row["Origins"]; 9 10 $q = "UPDATE TLinks SET Origins = " . $origins + 1 . " WHERE LinkID = 1"; 11 $r3 = mysql_query($q) 12 or die ("Error- Could not run Query: $q!\nError (" . mysql_errno() . ") - " . mysql_error()); 13 14 } The above lines cause the following error: Error- Could not run Query: 1 WHERE LinkID = '01a_gennote'! Error (1064) - You have an error in your SQL syntax near '1 WHERE LinkID = '01a_gennote'' at line 1 Please note that the error happends with reference to the SELECT query on line 2. SOLUTION To solve the problem, I had to remove '+ 1' following the '$origins' on line 10. The following code executes without any errors. 1 $sq = "SELECT * FROM TLinks WHERE LinkID = 1"; 2 $result = mysql_query($sq) 3 or die ("Error- Could not run Query: $sq!\nError (" . mysql_errno() . ") - " . mysql_error()); 4 5 if ($row = mysql_fetch_array($result)) 6 { 7 $link = $row['Link']; 8 $origins = $row["Origins"]; 9 10 $q = "UPDATE TLinks SET Origins = " . $origins . " WHERE LinkID = 1"; 11 $r3 = mysql_query($q) 12 or die ("Error- Could not run Query: $q!\nError (" . mysql_errno() . ") - " . mysql_error()); 13 14 }