condition not working in nested loop in php

Question

for ($x = 0; $x <= 3; $x++) {
    for ($y = 0; $y <= 4; $y++) {
        if ($y == 0) {
            mysql_query("insert into tb_weight_rate_management 
                       (nation,zone_id,rate) values ('Domestic',1,'$del_100')");
        }
    }
}

hello i am little troubled using for loop....in the code above i have two loops ...1st loop will work 3 times and the the inside loop will work 4 times.... now when i click on submit button then it checks loop one and then enter second loop and inserts data 4 times in the database....which is wrong...i want if $y=0; then it should insert data only once but it is inserting data 4 times can anyone please correct the above condition

ohk but it is not working like that also i have tried it using == — user3181292
– user3181292, Commented Jan 22, 2014 at 7:54
what is y doing here ? why are you creating a loop ? you just using y ONE TIME — Alireza Fallah
– Alireza Fallah, Commented Jan 22, 2014 at 7:56

Lajos Veres · Accepted Answer · 2014-01-22 07:53:58Z

1

You should use == instead of =. Like this:

if ($y == 0) {

answered Jan 22, 2014 at 7:53

Lajos Veres

13.7k7 gold badges47 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user3181292 Over a year ago

i did it but still it is inserting data 4 times

Lajos Veres Over a year ago

The first loop also has 4 iterations. (0,1,2,3)

user180100 Over a year ago

Because there is 2 loops!

cecilozaur · Accepted Answer · 2014-01-22 08:00:59Z

0

the first loop runs 4 times, hence 4 inserts In the inner loop you declare $y = 0 on every iteration of the outer loop

answered Jan 22, 2014 at 8:00

cecilozaur

7055 silver badges6 bronze badges

Comments

aman formuli · Accepted Answer · 2014-01-22 08:19:52Z

0

for each x iteration, there are one time y=0. and since x executes 4 times (0, 1, 2 and 3) y gets 0 value 4 times as well. if you want to do the insertion only once then you must add x value as well like if($y == 0 and x == 0).

answered Jan 22, 2014 at 8:19

aman formuli

111 bronze badge

Collectives™ on Stack Overflow

condition not working in nested loop in php

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related