Separating mysql fetch array results

Question

i have a mysql table the contains an index id, a data entry and 10 other columns called peso1, peso2, peso3...peso10. im trying to get the last 7 peso1 values for a specific id. like:

    $sql = mysql_query("SELECT * FROM table WHERE id='$id_a' ORDER BY data DESC LIMIT 0, 7");

when i try to fetch those values with mysql_fetch_array, i get all values together.

example:

    while($line = mysql_fetch_array($sql)) {

echo $line['peso1'];
    }

i get all peso1 values from all 7 days together. How can i get it separated?

what is the output and what is desired?

user2312578
– user2312578

2014-06-08 17:39:17 +00:00
Commented Jun 8, 2014 at 17:39 — user2312578
– user2312578, Commented Jun 8, 2014 at 17:39

Kevin Lynch · Accepted Answer · 2014-06-08 17:46:57Z

1

They will appear all together because you are not separating them as you loop through them.

for example, insert a line break and you will see them on separate lines

while($line = mysql_fetch_array($sql)) {
    echo $line['peso1'] ."<br />";
}

You could key it as an array like so

$myArray = array();
$i = 1;

while($line = mysql_fetch_array($sql)) {
        $myArray['day'.$i] = $line['peso1'];
        $i++;
}

Example use

$myArray['day1'] // returns day one value
$myArray['day2'] // returns day two value

answered Jun 8, 2014 at 17:46

Kevin Lynch

24.7k3 gold badges38 silver badges39 bronze badges

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

Comments

halabuda · Accepted Answer · 2014-06-08 17:37:33Z

0

It's not clear what you mean by "separated" so I'm going to assume you want the values as an array. Simply push each row field that you want within your while loop onto an array like this:

$arr = array();
while($line = mysql_fetch_array($sql)) {
  $arr[]=$line['peso1'];
}
print_r($arr);//will show your peso1 values as individual array elements

answered Jun 8, 2014 at 17:37

halabuda

3842 silver badges12 bronze badges

2 Comments

Lucca Zenobio Over a year ago

thanks. i want to be able to get each element of this new array. how can i do that?

halabuda Over a year ago

in the case above you would reference the array index, so for example if you wanted the 3rd array element you would reference it like this: $arr[2]. accessing array elements is too broad a topic for me to give you specific advice without knowing the intricacies of your objectives.

Collectives™ on Stack Overflow

Separating mysql fetch array results

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related