I am pretty new to PHP and just spent several hours watching video and wrote first PHP code. I meet one problem with display PHP fetch data to frontend html table. Below is my database, code, and frontend page. This…
I need assistance in building this custom query. Given this data: f_id sub_id field_name field_val 79 263 track_id 57162 80 263 track_title Antoniomontes 81 263 info_2 green 82 263 others older 83 264 track_id 37164 84 264 track_title veinticuatro treintado…
I try to replace 2023 to 2024 in WordPress post_title and post_name(slug), as below: UPDATE `wp_posts` SET post_title = REPLACE(post_title, '(2023)', '(2024)'), post_name = REPLACE(post_name, '-2023', '-2024') WHERE (post_title LIKE '%(2023)%') and (post_type = 'post'); However, after executing the query,…
I have a table called scores. id is the auto-incremented primary key. id player_id score 1 1 100 2 1 57 3 2 434 4 3 11 5 3 132 6 4 32 7 4 100 8 4 21 Given…
Hi I have the following table, FILE_NAME MODIFIED_DATE PRIORITY A 2022-10-11 1 A 2022-10-03 1 A 2022-10-02 1 B 2022-10-11 3 B 2022-10-01 3 C 2022-10-11 2 D 2022-10-11 4 I would like to order the table based on MODIFIED_DATE,…
I want to condense my database, which now contains a large number of values, to 1/12 of the original size by averaging twelve consecutive values. To do this, I form the mean value using the types TIMESTAMP and FLOAT(4,2). In…
I have a Next js application that I'm trying to dockerize. It shows an error while migrating Prisma. It uses MySQL as a base docker-compose.yml version: '3.8' services: mysql: container_name: discord-mysql restart: unless-stopped image: mysql:8.0.26 command: --default-authentication-plugin=mysql_native_password environment: MYSQL_ROOT_PASSWORD: 12345…
So my query is CREATE TABLE POSITION( ID INT AUTO_INCREMENT PRIMARY KEY, NAME CHAR(2) NOT NULL ); and if i try to run this creation i receive ERROR 1064 (42000): You have an error in your SQL syntax; check the…
Im trying to create a table on mysql using php. i send an array containing the columnname and the actual data. the first position is the columnname and the rest is the actual data. Ive managed to create the table…
I'm converting my MyBB board to phpBB. The ONLY issue I'm having is that MyBB has quote tags like this: [quote="Username" pid="4993" dateline="1703638754"] But phpBB3 uses this: [quote="Username"] All I'd like to do is find any posts that contain the…