getJSON working on localhost just not online.

[c_shelswell]

Hi I can't figure this out. I'm populating a select box based on the selection of another. This is working fine on my machine but not online. Is there a reason this might happen.

 

my jquery on the first page:

$(function()
    {		 
	$("select#membersOrPublic").change(function()
	 {
		$.getJSON("get_categories.php",{id: $(this).val(), ajax: 'true'}, function(j)
		{
			var options = '';
			for (var i = 0; i < j.length; i++) 
			{
				options += '<option value="' + j[i].optionValue + '">' + j[i].optionDisplay + '</option>';
			    
			    if (j[i].optionValue == 0)
			    {
				  // no results have been returned
			    }

			}

			$("select#categoryList").html(options);
		})
	})
})

 

and my get page

$cats = $db->selectFromDB('site_categories', '', "where area='".$_GET['id']."'");


if (count($cats) > 0)
{
$json = "[";

foreach ($cats as $k => $v)
{
	$json .= "{optionValue: '".$v['id']."', optionDisplay: '".$v[DEFAULT_LANG]."'},";
}

$json = substr($json, 0, -1);

$json .= "]";

echo $json;

}
else
{
$json = "[";

$json .= "{optionValue: '0', optionDisplay: 'NO CATEGORIES PLEASE CREATE ONE'}";

$json .= "]";

echo $json;

}

 

I'm not getting any errors from my get page just can't figure why it's not working online.

 

any ideas?

 

Cheers

[c_shelswell]

Ok I've found what's causing it. One of the entries that is being populated is a test string of: 123456MOBcat"t"//\\''deü©ΣДçگẫ£$ which i presume is ballsing up my JSON?

 

is there a way to format this to stop if from happening?

[trq]

You might want to take a look at json_encode instead of creating json manually.

[c_shelswell]

excellent that's exactly what i'll do. Thanks for the info. Love this forum somebody always knows the things you don't!

 

Cheers