The rows are indexed by number and then contain an array of the columns.
So this would work, but you probably want to loop over $rows:
$rows = $sth->fetchAll(PDO::FETCH_ASSOC);
$name = $rows[0]['MyID'];
echo $name;
When you fetch only one row it is just an array of columns:
$row = $sth->fetch(PDO::FETCH_ASSOC);
$name = $row['MyID'];
echo $name;
-Shawn
On Mon, May 19, 2014 at 6:57 PM, ICCSI <inungh@xxxxxxxxx> wrote:
> I have following code to fetch data from database.
> I am able to print the array, but I got HTTP 500 error when I assign the
> array the value to echo the result.
>
> I think I am missing something between array and variable.
>
> Your help and information is great appreciated,
>
> Iccsi,
>
>
> $row = $sth->fetchAll(PDO::FETCH_ASSOC);
> print_r($row);
> print("\n");
> $name = "{$row['MyID']}";
> echo $name;
>
