Selecting data in php - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

lapunluyang · 03-20-2011, 11:15 PM

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

anderson111 · 03-22-2011, 01:09 AM

This one is the Perfect query........

ap2010 · 03-22-2011, 05:10 AM

How are the two tables linked to each other? Do you have a foreign key or something in the quotes table?

chunnilal · 04-08-2011, 12:11 PM

It seems that Id is the PK and FK,
Y dont u use Joins?

websonalized · 04-08-2011, 06:11 PM

Code:

SELECT t2.quote, t2.author, t1.profession
FROM table2 t2
  LEFT JOIN table1 t1 ON t2.author = t1.author

OR, if author's table1's id = author's table2's id you could do:

Code:

select t2.quote, t2.author, t1.profession
   from table1 t1, table2 t2
   where t1.id = t2.id

sweetsianjali · 04-14-2011, 02:54 AM

hello websonalized

thanks for sharing this code

sweetsianjali · 04-15-2011, 07:35 AM

I have just try this code it's working,Thank you.

Euflexxa
Buy Actonel Online
Buy Orthovisc

danieljames123 · 06-17-2011, 01:12 AM

I also thanking you because it is also help to me. And I think you are great helper here.

_____________________
Php Development India

jacqueline_davic · 06-24-2011, 02:43 AM

thank you for that

rahaul · 06-28-2011, 02:10 AM

SELECT dbnames.tablenames.columnnames,db2names.table2name s.column2names FROM
dbnames.tablenames, db2names.table2names;
Thank you.

MBA | MBA Colleges in Mumbai