CODEWITHSUNDEEP
phpsqlarrayssql-serverrows
PHPNewbie
PHPNewbie

Reputation: 247

Access one row in an array PHP

I have this while loop in php:

<?php while($percentSKU = sqlsrv_fetch_array($resultSKU, SQLSRV_FETCH_ASSOC)) : ?>
    <p><?php echo $percentSKU['PercentageSales']; ?>%</p>
<?php endwhile; ?>

Which out puts 12 rows, for example:

.00%, .00%, .00%, .00%, 26.22%, .00%, 3.96%, 1.49%, 5.23%, 20.88%, 42.22%, .00%

Is there a way to only print out 1 particular row?

I have tried things like this:

<?php echo $percentSKU['PercentageSales'][4]; ?>

But because the the array returns a sting, I am getting the nth single character not the nth row of data. So instead of getting '26.22' im am getting '2'

Any ideas?

Upvotes: 2

Views: 2120

Answers (2)

Vladimir Medinsky
Vladimir Medinsky

Reputation: 102

working with mysql I use that function: 

function ExecuteQuery_assocArray($query) 
{
  $result = mysqli_query($this->link, $query);
  $set = array();
  while ($set[] = mysqli_fetch_assoc($result)); 
  return $set;
}

it returns $set of rows

Upvotes: 0

5eeker
5eeker

Reputation: 1027

If it is returning a string you can convert it to an array and access it via its index. To convert a string to an array you can use the explode function.

for ex : 

$string = '.00%, .00%, .00%, .00%, 26.22%, .00%, 3.96%, 1.49%, 5.23%, 20.88%, 42.22%, .00%';

$result = explode(',' $string);
$finalvalue = $result[0];

Note : The $result[0] will return the first value of the string, you will have to set the index which you require.

Upvotes: 2

Related Questions