date & refresh problem

[akaki]

Hi Everyone, Please provide me 2 solution:

1) I m inserting data in a table. but after submitting once, when i refresh the page, then same data insrted again. I declared a field named "Sl_No" as primary key+autoincrement.

2) I want to retrive records as month wise from table. At present i m inserting dates in "Date" field as date type(such as 2007/05/22). I create a drop down list box consists of 12 month as (January....December values 01...12). So, i just select 1 month, click search button & retrive all records in that whole month in another page. So, I need the sql query(also how i can use in php that query) & example of code if possible. Please provide.
Thanks...

[sidsel]

1. This is a general problem with page reloading.
   One solution is to set a session flag once your data has been entered into the table, and before inserting check if the flag has been set.

2. If you are using mysql, dateformats look like this '2007-05-22'.
   Query example: SELECT * FROM table WHERE MONTH(yourdatefield) = 2; // would return all records from February

[akaki]

Thanks.
But can u provide the codes to set a session flag?i know about session but i did not use session flag before, plz.

[Weedpacket]

akaki wrote:

But can u provide the codes to set a session flag?i know about session but i did not use session flag before, plz.

It's just an ordinary session variable. Its value doesn't matter, you just want to know if it's there or not.

[akaki]

I tried in my index.php page, but it did not worked. parhaps some is wrong. I told u that i did not usesession before. So, please give me an example of session variable to prevent the refresh problem.

*) Another thing is that, i declare a field named "Sl_No"(mysql). It is primary key & autoincrement. but phpmyadmin is not allow me to give a default value, is it not possible?

*) After deleting a record, the Sl_Number is permanently lost. Suppose, i stored a record 101. But if delete records of this number, than next 102 will come, but not 101 anymore. Plz try to provide examples so that clear to understand. Thankxxx...