[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.
can anyone tell me how can i acheive this...???

[End User]

Originally Posted by swap_ssj

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).
can anyone tell me how can i acheive this...???

Use a loop to insert the required number of entries, something like this:

PHP Code:

$num_records = 31;



for($i=1; $i=$num_records; $i++){

     //...your SQL code goes here

    $sql = INSERT INTO mytable (id, name, info) VALUES ('$id', 'Bob', '')";

    $sql_result = mysql_query($sql);



} 

This will insert 31 records for January as per the '$num_records' variable