From: Achuthan (achuthandryahoo.com)
Date: Fri Feb 20 2004 - 09:01:22 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

hi all
I am facing a problem in fetching the data from two different tables
I have tables called A and B.
Thro PHP code i am trying to connect to MySQL to fetch the desired datas frm both A & B
My code Goes like this
 
"select ename,exp,salary from A Union select ename,exp,sal from B LIMIT 0, 30"
 
Case1:
I could find the following inferences when i execute on my Local Host
- The Query is working very well & i could get the datas from A & B on my Localhost
My Localhost has PHP (4.2.3), MySQL(3.23.39) and phpMyAdmin(2.3.2)
I am happy with my Query when i execute.
 
 
Case2:
I could find the following inferences when i execute on the Online Server
- My Query is throwing the following error
You have an error in your SQL syntax near 'UNION select ename,exp,sal from B LIMIT 0, 30.
My Online server has PHP (4.3.1), MySQL(3.23.54), phpMyAdmin(2.5.1)
What will be the rootcause for my problem can anyoen Help me out to find the Bug???

Thanks in advance
Longing to get the solution
Regards
Achuthan

---------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]