|
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: Question | keshab gopal rout | 08/24/07 08:53 |
| import excel data to mysql through php | pooja | 07/06/07 04:51 |
| Code PHP and Mysql | TUY PHEARIN | 07/05/07 07:33 |
| Question | Kirti Mishra | 07/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. | ||


