You are viewing our Forum Archives. To view or take place in current topics click here.
C# MySQL Insert Help
Posted:

C# MySQL Insert HelpPosted:

FSE
  • Wise One
Status: Offline
Joined: Apr 28, 201113Year Member
Posts: 558
Reputation Power: 24
Status: Offline
Joined: Apr 28, 201113Year Member
Posts: 558
Reputation Power: 24
Ok, So I have a MySQL Database called "Login".

This is for C#

The structure is as follows:
username,
userlevel,
password,
ip

I have a login form that checks if the username and password is in the database.
Then I want to insert the current IP into the users row.

I already have the method that gets the current IP.
#2. Posted:
7en
  • V5 Launch
Status: Offline
Joined: Aug 16, 201212Year Member
Posts: 598
Reputation Power: 29
Status: Offline
Joined: Aug 16, 201212Year Member
Posts: 598
Reputation Power: 29
I'll ignore the many problems with your schema design and focus on the question at hand..

But what is the question? I'm not trying be smart, but what do you need help with? I'm assuming since you haven't posted any code that you haven't even made an attempt?

[ Register or Signin to view external links. ]
#3. Posted:
FSE
  • Wise One
Status: Offline
Joined: Apr 28, 201113Year Member
Posts: 558
Reputation Power: 24
Status: Offline
Joined: Apr 28, 201113Year Member
Posts: 558
Reputation Power: 24
7en wrote I'll ignore the many problems with your schema design and focus on the question at hand..

But what is the question? I'm not trying be smart, but what do you need help with? I'm assuming since you haven't posted any code that you haven't even made an attempt?

[ Register or Signin to view external links. ]


My Question is how would I insert the users IP into the their appropriate row?
First off, explain why my schema design is bad.
and I have attemped. Why would I post code that doesn't work?

Please think of what you are saying before you say it.
Jump to:
You are viewing our Forum Archives. To view or take place in current topics click here.