How to store values of elements of fetched rows in PHP?

Asked May 25 '15 at 21:12

Active May 25 '15 at 21:18

Viewed 20 times

I am trying to fetch a row from MySQL DataBase in PHP for a particular id. After Fetching I want to store individual elements of the row in some variables, which are to be used later in the webpage.

$sql = "SELECT * FROM complaints WHERE complainer='$fullname' AND id='$id'";
$result = $conn->query($sql);
if($result->num_rows==1)
{
    while($row=$result->fetch_assoc())
    {
         $department=row["department"];
         $complaint_type=row["complaint_type"];
         $subject=row["subject"];
         $detail=row["details"];
         $complaint_date=row["complaint_date"];
         $officer_responsible=row["officer_responsible"];
         $complaint_status=row["complaint_status"];
         $reminder_sent=row['reminder_sent'];

    }
}

I am doing this, but it throws an error while assigning values

Parse error: syntax error, unexpected '[', expecting ',' or ';'

Whats wrong in it?

edited May 25 '15 at 21:18

Funk Forty Niner

74,450
15
68
141

asked May 25 '15 at 21:12

Sankalp Malik

2

Variables needs a `$` in front . – Rizier123 May 25 '15 at 21:13
The variables used to store elements of the rows already have $ prefixed – Sankalp Malik May 25 '15 at 21:14
yeah, the way that code's all bunched up like that, no wonder it's hard to tell them apart – Funk Forty Niner May 25 '15 at 21:26

How to store values of elements of fetched rows in PHP?

0 Answers0