<span class="resolved" aria-label="Resolved" title="Topic is resolved."></span>mysql query for predictions

Replies: 1

Hi Antoine

I am running the Qatar league on a test basis with only 2 users me being one of the users. Even though I have made my predictions the other user could not submit them in time and right now he has 4 matches without predictions, those matches are already finished. Without having to deal with changing dates for the matches in the admin area, is there an SQL query that will allow me to insert the predictions into the predictions table for specific users? I know the match ids, and the user ids, therefore, I can get the values, but for me to be 100% sure I am using the correct statement, I would like you (if possible of course) to have the syntax for inserting the values into the table.

I am confident with running SQL scripts, but I want to be 100% sure I am doing it right, and this is the reason I am asking you for the syntax.

Kind Regards
Periklis

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer