Update table using SQL or CSV
-
I have create a page with a ‘wpdadiehard’ shortcode. I have create the project and page with “Bulk actions allowed” and “Import allowed”. If , on my page, page_id=4749 , I cliked on import, I get the prompt for import, I chose the file, which is an SQL file, and press “import”. It import no rows. What I am trying to accoplish is to import new participants for an event. But I would also like to update a specific field for existing participants Is this possible from a Front_end WordPress Page without having to log into the Admin pages? I nee a easy way to update participants of an event Examle SQL: Update existing participants : update g_tour_entries set tour_handcap = ‘1’ where tour_id = ‘2024-04’; Inserting new participants : INSERT INTOg_tour_entries(tour_entry_id,member_id,tour_id,tour_handicap,golf,meal,raffel,tour_tee,flight_pos,flight_nr,team_id,start_time,2_pot,game_id,reserved) Values (‘2024-01-395′,’395′,’2024-01′,(get_handicap(395)),’1′,’Kabeljauw’,”,’LT’,’2′,’Flight01′,”,’16:00′,”,”,’0′); INSERT INTOg_tour_entries(tour_entry_id,member_id,tour_id,tour_handicap,golf,meal,raffel,tour_tee,flight_pos,flight_nr,team_id,start_time,2_pot,game_id,reserved) Values (‘2024-01-523′,’523′,’2024-01′,(get_handicap(523)),’1′,”,”,’M’,’3′,’Flight03′,”,’16:00′,”,”,’0′);The page I need help with: [log in to see the link]
Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
The topic ‘Update table using SQL or CSV’ is closed to new replies.