CODEWITHSUNDEEP
phpmysqli
user3855343
user3855343

Reputation: 43

mysqli query to fetch row values without loop

I am newbie and need help to resolve my issue.

extract row values without loop.

Table:

 ----------------
  YEAR  | SALES
 ----------------
 2011  |     45
 2012  |     34
 2013  |     23
 2014  |     10
 2015  |     48
 ----------------

PHP code:

$sql = "SELECT YEAR FROM MyGuests";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "YEAR: " . $row["YEAR"]. "<br>";
    }
} else {
    echo "0 results";
}

looking for solution to output the year value without loop , something similar below while loop prints all row values , but would like to extract individual year value from query and assign it to a variable

$year1 = $row["YEAR"]
$year2 = $row["YEAR"]
$year3 = $row["YEAR"]

Upvotes: 0

Views: 1656

Answers (1)

SJB
SJB

Reputation: 313

with your current code

       $i=1;
       while($row = $result->fetch_assoc()) {
           ${'year'.$i}= $row["YEAR"];
           $i++;
           //echo "YEAR: " . $row["YEAR"]. "<br>";
          }

now you can access $year1; $year2 and so on

Upvotes: 1

Related Questions