Sr. Web Developer
mediabistro.com
US-NY-New York

Justtechjobs.com Post A Job | Post A Resume

Comments for: vince_barnes20070613

Message # 1510193:
Date: 08/24/07 08:53
By: keshab gopal rout
Subject: RE: Question

There are various option will come across while u r fetching records from 3 table...
if theere any common field in three table then it's quite easy ...
fot that the code will like below...

$query = "SELECT a.*,b.*,c.* FROM first_table a,second_table b,third_table c WHERE a.commonfieldname=b.commonfieldname=c.commonfieldname"....

if suppose the first table has common field with second and third,but no common between second and third...
then the code is...
$query = "SELECT a.*,b.*,c.* FROM first_table a,second_table b,third_table c WHERE a.commonfieldname=b.commonfieldname AND a.commonfieldname=c.commonfieldname"...

as i told lots of case will arise....
it's better if u wxplain what kind of result u want to comeout..and what r the relatons between tables...

but for ur queck reference..plz go to..
http://www.plus2net.com

thank u..
keshab

Previous Message | Next Message


Comments:
RE: Questionkeshab gopal rout08/24/07 08:53
import excel data to mysql through phppooja07/06/07 04:51
Code PHP and Mysql TUY PHEARIN07/05/07 07:33
QuestionKirti Mishra07/04/07 03:30
 

If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly.

Add A Comment:

Name:

Email:

Subject:

Message:

To reduce spam posts, messages are now manually approved

You are not [logged in]. That means your account will not get credit for this post.