newcoder2023

Sorry typo week number !

Hi there, how do i get data from all tables in my database for example if i have a database called test and tables test1, test2, test3 etc how do i make a query for each table also If i have a row in each database table called date (name date type date) how do i convert this to the relevant week number of that date ? So for example if the row date had 2023-11-17 i want to convert it to 46 (week number) I have a table of week numbers (week 1 to 52) so in the above example in my table i want to display whether week 46 is valid or not (dependant on if date was entered) using an if else statement so if week 46 was not entered in my form, in week 46 in my table it would say "No" but if i entered a date (as above) in week 46 in my form, in my table it would say "Yes" I hope this makes sense so test1 , test2, test3 tables i want to convert date to week number then in my html table at side i have test1, test2, test3 down the side and across the top i have week 1 to 52 in the date example above if test1 table date was empty it would say in the html table "no" else if it had a date it would say "yes" as daft as this sounds something like this : <td>convert date to week number then if test1 week number 46 is empty say "no" otherwise say "yes"</td> <td>convert date to week number then if test2 week number 46 is empty say "no" otherwise say "yes"</td> i know it sounds complicatd Thanks