hi friendz
I want to get data from two tables

Example
table 1 with fields id,author,profession,country

table 2 with fields id,quote,author,category

So in this way i want to select quote from table 2 whose author and profeesion is specific

$result = mysql_query("SELECT quote FROM table 2 where author="harry" and profession = "Scientist");


Is there any way that i can select like this

This isn't a php question, it's a basic db query question. Start with http://dev.mysql.com/doc/refman/5.1/en/select.html and read on to the Join page.