foreach inside a while loop in getting row value...?

Question

Here's my code:

$inv = array('field1','field2','field3','field4');
$sql = "select * from table1 where id='1'";
$result = mysql_query($sql);
if(!$result){
    print mysql_error();    
}else{
    while($row = mysql_fetch_array($result)){
        foreach($inv as $i){
            print $row[$i];
        }
    }
}

table1 consist of the following field name: field1, field2, field3, field4, field5, field6, field7
$inv = explode(',',$item) where $item = table2 $row[value] return a string with comma delimited which may consist 'field1,field2,field5' or 'field3,field4,field6'...etc.

How come it only print the value of field1? What's wrong with this code?

    while($row = mysql_fetch_array($result)){
        print $row['field1'];
        print $row['field2'];
        print $row['field3'];
        print $row['field4'];
    }

But if I do this way it will print all the value.

by the the fields name are dynamic that's why i need it to be like that. — user2138394
– user2138394, Commented Mar 14, 2013 at 3:18
$inv is already an array, why are you exploding it. print $i and see what the results are. I bet not what you think. — Leeish
– Leeish, Commented Mar 14, 2013 at 3:20
@user2138394 I can see from the revisions that you removed the explode line, which is (was?) the critical point others point out. Are you removing it because it isn't in your actually code? — Passerby
– Passerby, Commented Mar 14, 2013 at 3:25
thanks for the answer i just found my mistake, it's just a white space that i need to trim down. Thanks! — user2138394
– user2138394, Commented Mar 14, 2013 at 4:04

Thomas Hambach · Accepted Answer · 2013-03-14 03:20:30Z

4

You are using explode() on an array. Explode is used to create an array from a string. You do not have to do this, please refer to the manual http://php.net/explode to understand. Change the lines below

$inv = array('field1','field2','field3','field4');
$item = explode(',',$inv);

to

$item = array('field1','field2','field3','field4');

answered Mar 14, 2013 at 3:20

Thomas Hambach

3072 silver badges11 bronze badges

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

3 Comments

Leeish Over a year ago

Right. Unless you $item = 'field1,field2,field3,field4' there is no reason to explode. @user2138394

user2138394 Over a year ago

sorry i forgot to edit the question, $inv = another table $row['value'] that return a comma delimited string.

user2138394 Over a year ago

thanks for the answer i just found my mistake, it's just a white space that i need to trim down. Thanks!

jeroen · Accepted Answer · 2013-03-14 04:06:25Z

0

Based on your edit I would guess that your field names contain leading spaces. You should check that with a var_dump() of the $i variables and you can solve it by trimming it:

$i = trim($i);

answered Mar 14, 2013 at 4:06

jeroen

91.8k22 gold badges117 silver badges132 bronze badges

Collectives™ on Stack Overflow

foreach inside a while loop in getting row value...?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related