genius_supreme

batwimp.. thank you very much on your reply... and my bad i posted in the wrong section the sql query is just a simple one to give you and idea how bad i am in this part of the world and i really appreciate the explanation. Now i know how sub-select works.. what i'm trying to accomplish: i have 3 tables (tblmember,tblspouse,tblchildren) for family details and contact record which UNION with field:FamilyName. tblmember consists of additional 5 fields for contacts details such as address,postal,state,etc. Each tables also has a field for membership status field:MembershipType. i would like to generate a "report" in csv format where the records are exported based on membership status selected from the dropdown list on the reports.php page. Once clicked on the submit button the query will do the "magic sql" to capture the selected fields from all the 3 tables based on MembershipType = $_POST['dropdownlist'] I have done a search query using UNION where the user enters anypart of the "member name" and the query will look into field:MemberName in all 3 tables and displays the selected fields from all 3 tables onto the page itself (no export). can i combine the SELECT * INTO OUTFILE with UNION? as i received an error "incorrect usage of UNION and INTO". so how do i use UNION with SELECT INTO OUTFILE? and is this the right way? i have run 2 separate test query: 1) with UNION works well on all 3 tables just to print on page in tabulated format 2) with INTO OUTFILE works well to export only with one table is there a way to have 1 query to do the both?

Dear freak gurus out there, I'm new to php and sql as i learn from online examples . Though there are lots of links and answers out there related to my post but none reflects what i need. You guys my only hope. What i have: 3 tables : each has its own number of fields (tbl1=14 ,tbl2=9,tbl3=9). There is a field in each tables that can be related (FamilyField). What i need: export to csv all the records from all 3 tables which relates to search criteria (by user) based on a field (MembershipField) which the data may vary from other tables. pseudo code: $membership_type =$_POST['mtype']; $sql=" SELECT field1,field2,field5,MembershipField from tbl1, (SELECT field1,field2,MembershipField from tbl2), (SELECT field3,field6,field8,MembershipField from tbl3) WHERE MembershipFied=$membership_type"; export to csv file by using INTO OUTFILE; I have tried all the code i can find to export from 1 table to csv, and i manage to use UNION to get output from 3 tables but unable to export as the error message was "incorrect usage of UNION and INTO. is this possible? or any workaround? guides with samples will be a great help.

Thanks phpchamps. I was testing the php file at the time u replied. and it works . thanks for the great article too. now i need to put my scripts together to send the mails out based on the date.

hey phpchamps, i was thinking about that but never know the scheduler can run php files. can it? If i create a php file to check on the NotifyDate=CurrentDate and send out the email (another php file) will the scheduler run accordingly? thanks for you reply. Need more infor.

im using WAMP. I have just learnt that cronjob only works for linux so is there any other method to do what i want?

Hi guys im new to this forum hope i posted this on the right topic. the scenario: i have a form completed with form validation. This form has to be saved in database. And the details of that particular form information (saved by form ID) has to be emailed to certain people (by mailing group selected in the form which links to another table consisting of the email addresses assigned to that email group) but the tricky part is that it has to be sent as a reminder based on number of days input in the form (reminder_day field) by the user. The form also consist 2 attachment fields which are supposed to be sent as email attachment (the file location is saved in database as attachment_field1 and attachment_field2) Help/idea/suggestion required on: sending out the details as an email reminder including attachment (if there are any) based on the NotifyDate field ("reminder_day field" + current Date) in the Database. This has to be automatically sent when that date arrives (NotifyDate). Sample code preferable for better understanding. Actually this is an Intranet Application for my office. Need your experties. (please refer the attached php form) [attachment deleted by admin]