|
I have been using the log in tutorial on the Unity forum and the phphandler scripts up till now with no issues. But I seem to be stuck when it comes to updating the database at run time. I'm pretty sure its my PHP command. See Below: ////////////////////////////////////////////////////////////////////////////////// $SQL = "SELECT * FROM players WHERE gameName = ' " . $gameName . " ' AND playerPassword = ' " . $playerPassword . " ';";
/////////////////////////////////////////////////////////////////////////////// I can't seem to find the Syntax Error. Are ther any tutorials show mySQL updating at runtime for Unity?? Thanxs Christian
(comments are locked)
|
|
You are trading off your quotations too often. It should follow a pattern like this:
In short, you ended up trying to assign the SQL column $strengthMax to a php variable "strength" (backwards from what it should be) in your sql command...if you fix all that syntax it should work appropriately. If you write your php in a program like Notepad++ or Dreamweaver, it should be much easier to see where your syntax errors are. Thanxs I got rapidPHP and that helped see my syntax error. The final version of the function is on :
Oct 06 '10 at 09:06 AM
SoloChristian
(comments are locked)
|
|
If ur doing this make sure to clean the $varibles to prevent SQLInjections
(comments are locked)
|
