TalkPHP - View Single Post

h0ly lag · 05-08-2008, 05:45 PM

Ok, so I'm trying to code a user profile page. Pretty simple. All I need it to do is to get the user data, like username, maybe their email, join date. All the standard things. Anyways, the thing I'm having problems with is I need to select the row of the user by using $_GET. So my URL look like this "user.php?id=1". What I need to do is by using $_GET to find the user ID in the database then selecting that row and pulling the data I need from it. I'm having troubles selecting the row using the ID number. I'm not too MySQL savvy.

I have a column named `id`, `username`, and `email`. How do I select this by using the ID number and output it?

05-08-2008, 05:45 PM	#1 (permalink)
h0ly lag The Contributor Join Date: Apr 2008 Location: Nevada, USA Posts: 52 Thanks: 10	User profile page Ok, so I'm trying to code a user profile page. Pretty simple. All I need it to do is to get the user data, like username, maybe their email, join date. All the standard things. Anyways, the thing I'm having problems with is I need to select the row of the user by using $_GET. So my URL look like this "user.php?id=1". What I need to do is by using $_GET to find the user ID in the database then selecting that row and pulling the data I need from it. I'm having troubles selecting the row using the ID number. I'm not too MySQL savvy. I have a column named `id`, `username`, and `email`. How do I select this by using the ID number and output it?