smd8061 Posted January 22, 2008 Share Posted January 22, 2008 Can someone please tell me how i would pull data from multiple tables in my database and then print the info in designated spots on a pdf file???? I know how send it to a pdf file and how to add it in the spots just not pull the multiple info and post it all side by side. I'm sorry in advanced if this explanation is not clear enough. I will try to be more clear when i reply. Thank you all, smd8061 Quote Link to comment Share on other sites More sharing options...
dessolator Posted January 22, 2008 Share Posted January 22, 2008 Hi, you will need a join statement. What I do is replicate the database in access, setup the relationships then create a query for all the data that you want. Then you can go to SQL view and the code is generated (you may need to change a few small bits tho, when you run it in phpmyadmin). As there are several types of joins this is the easiest option. Ian Quote Link to comment Share on other sites More sharing options...
smd8061 Posted January 22, 2008 Author Share Posted January 22, 2008 Hi, you will need a join statement. What I do is replicate the database in access, setup the relationships then create a query for all the data that you want. Then you can go to SQL view and the code is generated (you may need to change a few small bits tho, when you run it in phpmyadmin). As there are several types of joins this is the easiest option. Ian Thank you very much. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.