Jquery getJSON returning 'undefined'

Question

I'm trying to run a simple getJSON to a PHP file using:

$.getJSON("loadThumbs.php", { usrID: 25 }, function(data){
  alert(data.filename);
  });

And when the alert messages pops up it reads "undefined."

Here's my PHP file (loadThumbs.php):

$usrID = $_GET['usrID'];

$sql = "SELECT id, isDefaultProfile, filename, usrID FROM profile_images WHERE   isDefaultProfile=1 AND usrID='$usrID'";
$result = mysql_db_query($DBname,$sql,$link) or die(mysql_error()); 

$rows = array();

while($r = mysql_fetch_assoc($result)) {
   $rows[] = $r;
 }
print json_encode($rows);

//Which outputs: [{"id":"5","isDefaultProfile":"1","filename":"26.jpg","usrID":"25"}]

Any ideas on what I might be doing wrong?

Are you sure that the usrID field is making its way to the server? Try rewriting the {usrID: 25} line to {"usrID": 25}. — David Andres
– David Andres, Commented Sep 19, 2009 at 17:34

Paolo Bergantino · Accepted Answer · 2009-09-19 17:34:38Z

5

Try:

alert(data[0].filename);

The JSON being returned is an array (the brackets) containing one object (the curly braces), so you have to access the first element of the array to be able to get the filename of the first file.

answered Sep 19, 2009 at 17:34

Paolo Bergantino

490k83 gold badges524 silver badges437 bronze badges

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

1 Comment

Dodinas Over a year ago

That was it. Makes sense now. Thanks!

Collectives™ on Stack Overflow

Jquery getJSON returning 'undefined'

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related