Please help me...!!!

[swap_ssj]

hi guyes....

for the first time i came across the scenario like this.
can anyone tell me, how to insert multiple records in the same table under the same unique id dynamically...???

in my application, user selects year and month. then according to that month, user will have to insert specific no. of records (i.e. 31 records for January, 28 records for February).

so, i've to insert multiple entries for the same month in a same table, under same unique id.

i'm trying to do it in this way :

           for ($i=1;$i<$maxday+1;$i++)
          {								$sql = "INSERT INTO scheduledetail(scheduleid, date,litres,hours) VALUES($sid,$i,'$_REQUEST[litres]','$_REQUEST[hours]')";
							mysql_query($sql);
							$sql = substr( $sql, 0, strlen( $sql)-1 );

          }

after executing this code, proper no. of entries are added in scheduledetail table, but only scheduleid and date fields are shown properly, other fields are shown as zero.
i'm wondering why it's happening..

can anyone please tell me how can i insert proper values for all the fields...???

[laserlight]

swap_ssj wrote:

can anyone tell me, how to insert multiple records in the same table under the same unique id dynamically...?

That is like saying: I fully support the law that every voter is entitled to exactly one vote but I will do all I can to vote in the coming election a hundred times - let the authorities try and stop me!

The solution then, is not to be so illogical. Rather, create a table of records. Each record will have a foreign key that corresponds to a primary key in the scheduledetail table. So, the unique keys of the scheduledetail table are associated with multiple records, without violating the rule that the scheduledetail keys are unique. This is a typical solution when you have a one to many relationship, as you do here.