PHP/MySQL programming?

[sonjeriff]

hi , ive made a member profile page and i want to grab the member data from the mysql table and display it on the page.

i want to grab the data from the row associated with the member logged in.

thanks.

 

[Eric]

Well, it would depend on the structure of your database and how you're getting the member's id and/or username (however you check if they're logged in).

 

[Obulus]

Maybe looking into arraying the row that is assigned to the user logged in?

 

[BuLLDoG]

you need a function to grab a id of the profile such as:

$id=$_GET['id'];

then a WHERE clause in your SQL statement, something like:

SELECT * FROM members WHERE id = '$id'

Something along those lines

 

[hhelen]

Looks like the OP has found a solution to their database problem.

 

[rickmci]

you need a function to grab a id of the profile such as:

$id=$_GET['id'];

then a WHERE clause in your SQL statement, something like:

SELECT * FROM members WHERE id = '$id'

Something along those lines

This is exaaclty right. However, you will need to know what user is logged in in the first place and there are several ways to do that. id will = the user id assigned in you web page to the currently loged on user.

 

[stevemack]

also it depends on the structure of the db. i think BollDog has come up with the solution.

 

[trukin]

you need a function to grab a id of the profile such as:

$id=$_GET['id'];

then a WHERE clause in your SQL statement, something like:

SELECT * FROM members WHERE id = '$id'

Something along those lines

Make sure you use something like PDO or mysql_escape_string when using raw user input. You don't want to be dealing with SQL Injections.