How do you select data associated with a logged in user from your sql davabase using php?

Answer 1

Assuming you have the same table for the user-details and login. Also that you have got the login part working

<?php

// connection string statement

// select database statement

// check if user is present in db

$user = 'user_name'; // put the value of username obtained from login

$select = mysql_query("SELECT * FROM table_name WHERE user='$user'");

// if statement will check for single user before showing data

if(($fetch = mysql_fetch_array($select))&&($select>0)&&($select<2))

{

// only print the columns you want to show

echo $fetch['col_1']; // where col_1 is the name of column

echo $fetch['col_2'];

}

?>