Retrieving Data From MySQL for specific user.

[jassikundi]

Hi everyone, I'm trying to retrieve data from my mysql database using php. I've got a table called completed_quote and would like to retrieve  data from the columns (username, postcode, and completedquote) for a specific person who is logged into view the page.

 

I'm currently using $username to retrieve the username of the person from the session.

 

What modifications would need to be made to the php code below that retrieves the entire data from a table.

 

[pre]//Retrieves data from MySQL

$data = mysql_query("SELECT * FROM completed_quote") or die(mysql_error());

 

//Puts it into an array

while($info = mysql_fetch_array( $data ))[/pre]

 

Regards

Jassi

 

[craygo]

$data = mysql_query("SELECT * FROM completed_quote WHERE username = '$username'") or die(mysql_error());

 

Ray

[jassikundi]

Thankyou Craygo for the quick reply tested and working thankyou. 

[craygo]

Anytime, don't forget the solved button.

 

Ray