Relative Content

Tag Archive for phpmysql

Trouble with PHP coding

I have trouble with the final Lesson 29 from the book Learn PHP, MySQL and JavaScript. This time I’m using ServBay and when I try to open the site folder I got the error :

Ranking students grades Mysqli

i have an exams table with students scores for each subject in the same table. the problem is that i want to have a rank for each subject of a student. for example what is the students rank in english. the problem is that the ranking seems to be done by comparing all the students subjects. therefore not giving an accurate result.

How to gret lastInsertId() after using a temp table

I am duplicating a row within a table. The primary key should auto update, so I remove that Primary Key value (MenuID) from the select in a temporary table and allow the insert to create a value for the new row.