how to export some listed colums from two mysql table in one db into excel

Please I have two tables in one db and i what to export the data from some of the column (not all the columns in both tables) and both tables have one specific table the have same data in common thst’s file_no but other culmns are having different informations

What have you tried? What was the result? What is the expected result?

Not totally certain I understand what you want to do. But it sounds like you want to JOIN two tables on an common element? That would be an SQL “JOIN” query. You could then take your results of the query, step through each record with a foreach loop and write to a comma separated file to read into excel.

You are right. Please can u give me details on how to goo about it?

Here you go…

thanks

;D Too funny Kevin!

Sponsor our Newsletter | Privacy Policy | Terms of Service