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 Link to comment https://forums.phpfreaks.com/topic/87262-solved-how-do-i-pull-from-multiple-tables/ 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 Link to comment https://forums.phpfreaks.com/topic/87262-solved-how-do-i-pull-from-multiple-tables/#findComment-446349 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. Link to comment https://forums.phpfreaks.com/topic/87262-solved-how-do-i-pull-from-multiple-tables/#findComment-446350 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.