Ok I have been trying and trying for ages and I just can't figure this thing out basically I have an email for on my website where users will beable to edit their account information, and then have it sent to me in an email so I can change it on the database.
But I want them to see their existing information so they can make edits to it and add and delete stuff therefore I want to display the existing information in the boxes.
I've done it fine with the username and password due to a session already been created.
Don't bother sstalder.. He made a topic earlier, he doesn't know PHP and he doesn't know where variables in his SQL statement came from or what they contain (SQL is returning blank because $myemail and $myprofile are empty).
Like I said europeanteens, read the website I gave you a link to and get an understanding of PHP, because any answer we give you you won't understand. Until we know how you're getting the information for $myemail and $myprofile, it won't work.
You yourself don't know where that information came from except a friend telling you to write it. It must come from somewhere. Whilst it is empty, your page will not work as you want it to.
I highly suggest learning PHP before coding it. Using source from the internet will only get you so far.
Don't bother sstalder.. He made a topic earlier, he doesn't know PHP and he doesn't know where variables in his SQL statement came from or what they contain (SQL is returning blank because $myemail and $myprofile are empty).
Like I said europeanteens, read the website I gave you a link to and get an understanding of PHP, because any answer we give you you won't understand. Until we know how you're getting the information for $myemail and $myprofile, it won't work.
You yourself don't know where that information came from except a friend telling you to write it. It must come from somewhere. Whilst it is empty, your page will not work as you want it to.
I highly suggest learning PHP before coding it. Using source from the internet will only get you so far.
I'm getting the information from a MySQL database.
I'm getting the information from a MySQL database.
That's my point. You don't know what we're talking about.
I said "Where are you getting $myemail and $myprofile from in your SQL statement".
You said "I'm getting the information from a MySQL database".
Those variables need to be set BEFORE your statement, otherwise it WILL return no results, just like the problem you are having. The difference is you have no idea why you put those details because someone "told" you to do it.
You obviously have no clue what you're doing. To further support that, you're manually updating peoples passwords for them by having them email it to you. Why don't they just update it themselves via your page? Because you probably don't know how to do it. So read the damn page I gave you a link to. It's a crash course in PHP / MySQL and it won't take you half an hour to go through. This only benefits yourself because everything about the page you've made is wrong, and I don't think there is a single person here who can help you without building your page from scratch. You need to help yourself first.
I'm not going to get pissed about it, because I don't have to help you.. Nobody here does, you need to help yourself by actually learning the basics rather than pinching bits of code you've seen on the internet, because that's not how you learn PHP.
So why am I posting? To help you. Learn the basics and then perhaps you will see why this doesn't work, and fix it, because we've told you why it doesn't work, but only you can fix that problem. $myemail and $myprofile need to be set. They need to match a persons record. They are variables that have no value, so they return no results. If you give them a value it will return results, and I told you HOW to do that in your other post, but again, since you don't understand PHP at all, you don't know how to implement it.
I want to display a users data in a form field.
basically I have an email for on my website where users will beable to edit their account information, and then have it sent to me in an email so I can change it on the database.
Reply With Quote
Originally Posted by maveruk
Bookmarks