contact

Problem continues...

I have thousands of records of an exam results for each student. I must give them an queue value. (And of course the highest point will get number 1, the second point will get number 2, etc.) The temp table has 2 fields: id: auto_increment, integer and primary sno: integer I wanna select the id as blank and sno from table "deneme" and wanna add them on the order of puan (desc). After adding all records to temp in order, i will update the all records' queue to temp's id by using temp's sno.

I have a list of student exam points and i wanna order them by using temporary table. Simply i use this code to do: insert into sm_temp select ' ' as id, sno from deneme order by puan desc The select statement works well if it's alone. But when i wanna use with INSERT, there's no error, but the order is wrong. For ex. the biggest point may gey number 1, the second may get 8, and the 3rd may get 59... How can i solve it? (It works well in Delphi with MSSQL.)

I have a everyday-updating and huge database table's CSV format (min. 10MB) and i wanna add/update it to the MySQL at server. But, because of its size i cannot decide what to do. I'm studying on local with PHP and MySQL, and on server PHP and MySQL. 1- At every changing on the this db's table, must i make a change on server's MySQL? (I'm beware of internet connection problems) 2- Must i convert db's table to CSV format at a particular time of a day and send it to server by "file upload"? (I'm beware of sending time's excess.) 3- While using "file upload", what must i do due to problems of timeout?

I wanna use cookies and sessions on my website. I had installed php5 manuelly, then it worked. But unfortunately this time, i cannot use some php functiouns and phrases. When i wanna view my page, there's nothing included: only a white page. What was the problem?