i'm doing VIEW function. and this is my Mysql statement:

$sql = "SELECT * FROM staff, student WHERE f_Username.staff LIKE '$user' OR t_Username.student LIKE '$user'";
$result = mysql_query($sql, $conn);

the result can be from table staff or student. now how am i suppose to display the result?

i'm am total newbie

__________________
i\'m am total newbie

i think you got your query the other way around. It should be like:

$sql = "SELECT * FROM staff, student WHERE staff.f_Username LIKE '%$user%' OR student.t_Username LIKE '%$user%'";
$result = mysql_query($sql) or die (mysql_error());

while ($row = mysql_fetch_assoc($result)){
    //Here you can print your data however you like.
    //$row is an array that contains all of your results and you can
    //display them like the following.
    echo $row['f_Username'];
}

----------------
Never bother to learn something not knowing which does not do you any harm, and never neglect to learn something whose negligence will increase your ignorance - Imam Jafar Sadeq

echo $row['f_Username']; -- will this display result from table student?

i'm am total newbie

if the fieldname is not unique between the two tables, you might have some problems. So to obviate this problem, either use the numerical index of the array or do this as your select statement.:

$sql = "SELECT f_Username as username, t_Username as staff_username FROM staff, student WHERE staff.staff_username LIKE '%$user%' OR student.username LIKE '%$user%'";


----------------
Never bother to learn something not knowing which does not do you any harm, and never neglect to learn something whose negligence will increase your ignorance - Imam Jafar Sadeq