Home Upgrade Search Memberlist Extras Hacker Tools Award Goals Help Wiki Contact

.NET 

.Net MYSQL Information Updating. Not working?

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.
[Image: 5Lxbaet.png]
There's a missing single quote(') in that query.

(Dec 5, 2016 10:54 PM)GruntStyl Wrote:  
PHP Code

<?php 
Dim sqlquery 
As String = "UPDATE Registration SET Username = '" & usr.Text & " (') WHERE User_number = '" & count.Text & "'" 


Possibly Related Threads...
Thread / Author Replies Views Last Post
[C#] by siimon00Sep 28, 2016 09:58 PM 5 202 Sep 28, 2016 09:58 PM
Last Post: some_dude13
[.NET] by Netflix and WeedApr 17, 2016 03:04 PM 4 149 Apr 17, 2016 03:04 PM
Last Post: Netflix and Weed
[.NET] by SIM-297877Feb 5, 2015 10:31 AM 2 74 Feb 5, 2015 10:31 AM
Last Post: Only3