/********** Update Column Value using rownumber ************
UPDATE exam_question_bank
SET question_number = (@rownum := 1 + @rownum)
WHERE 0 = (@rownum:=0)
AND subject_id=21
ORDER BY question_id
******************************************************/
How to setup Live Server extenion in VS Code for PHP
How to setup Live Server extension in VS Code and Live Server Web Extension in Chrome to automatically update the output i.e. without reloading the browser or refreshing the page.
Live server reloads your code after you save your code on VS editor.
First install Live Server Extension for VS Editor
Second install Live Server Extension for chrome browser
Chck the chckbox and provide live server address that is http://127.0.0.1:5500/yourProjectName/ and actual server address that is http://localhost/yourProjectName/
Now its ready to run.
Note: Don't forgot to give your projct folder name