Reference specific row's column value from array

Question

I have read a-lot of answers on this but they don't seem to be working.

I have the following code:

$amountoflikes=mysql_query("SELECT * FROM  `uc_likes` WHERE `dwable` =  '372'");

This returns the following:

If I wanted to echo the value of dwable in the 2nd row for instance (not involving the initial query).

I've tried:

while($row3 = mysql_fetch_assoc($amountoflikes)){
    $json[] = $row3;
    }
    echo json_encode($json);

But this returns null.

I'm currently using PHP 5.5 (native).

I'm not using MySQLi or MySQL PDO.

Can someone tell me where I'm going wrong. Ideally I'd prefer not to use a loop but I don't know if that's possible.

Thanks!

Have you tried echo $json[1]['dwable'] in place of your existing echo? — Craig
– Craig, Commented Sep 16, 2016 at 17:00
You need the loop if there are multiple records. Have you tried echo $row3['dwable'];? If you are doing `dwable` = '372' why even execute the query you know dwable will be 372. — chris85
– chris85, Commented Sep 16, 2016 at 17:04
@chris85 it turns out I think my initial query wasn't returning results with the variables (even though I echoed them out to check). — Ben
– Ben, Commented Sep 16, 2016 at 17:07

chris85 · Accepted Answer · 2016-09-16 17:02:49Z

1

Try declaring $json as an array above the while:

$json = array();

edited Sep 16, 2016 at 17:02

chris85

23.9k7 gold badges36 silver badges51 bronze badges

answered Sep 16, 2016 at 17:02

Rick Chen

1817 bronze badges

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

1 Comment

Ben Over a year ago

It turns out my initial query wasn't returning results with the variables in it (even though I echoed them out to check). However since I added this it changed from Null to [] which made me think this was the case. So thanks!

Dev. Joel · Accepted Answer · 2016-09-16 17:09:17Z

1

declare your array as follows

$json = array();

and see if you have results before your result

if ($amountoflikes)
{
  while(){...}
}

answered Sep 16, 2016 at 17:09

Dev. Joel

1,1471 gold badge9 silver badges14 bronze badges

Collectives™ on Stack Overflow

Reference specific row's column value from array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related