+- Hack Forums (https://hackforums.net)
+-- Forum: Tech (https://hackforums.net/forumdisplay.php?fid=444)
+--- Forum: Coding (https://hackforums.net/forumdisplay.php?fid=151)
+---- Forum: Software Development (https://hackforums.net/forumdisplay.php?fid=118)
+---- Thread: [.NET] .Net MYSQL Information Updating. Not working? (/showthread.php?tid=5485725)
.Net MYSQL Information Updating. Not working? - GruntStyl - Dec 5, 2016
I have wrote countless applications before using MYSQL.
I have no idea what the hell is wrong. I can connect to the database and everything, However It will not let me update values of specific Tables. I feel like I'm just frustrated at this point. Something that I have done before with no issues is hanging me up for the last 20-30 minutes.
PHP Code
<?php
Dim sqlquery As String = "UPDATE Registration SET Username = '" & usr.Text & "WHERE User_number = '" & count.Text & "'"
I know I'm accessing the database, I've done multiple connection tests and I can pull data from my server.
* - Rhez - Dec 6, 2016
There's a missing single quote(') in that query.
(Dec 5, 2016 10:54 PM)Tazzy0pz Wrote:PHP Code
<?php
Dim sqlquery As String = "UPDATE Registration SET Username = '" & usr.Text & " (') WHERE User_number = '" & count.Text & "'"