SQL query returns a null after first iteration

Asked Sep 20 '12 at 23:56

Active Sep 20 '12 at 23:56

Viewed 102 times

Please dont mind syntax errors, this is just a gist for the whole code

I got this webpage with the JS code below:

setInterval(function(){
  $.ajax({
    url: my_page.php,
    dataType: 'json',
    success: function(data){
      console.log(data.key);
    }
  });
}, 1000);

And my_page.php looks like this:

include database.php
$data = mysql_fetch_array(mysql_query("valid SELECT query"), MYSQL_ASSOC);
echo json_encode($data);

(Chrome) console shows this:

correct_result
null
null
...

Can anybody explain why? I have tested the query and is 100% correct, it echoes the correct result on first iteration anyway.

Thanks!

asked Sep 20 '12 at 23:56

yowmamasita

4,510
3
15
17

1

try `console.log(data)` to see what is coming through. – Timm Sep 20 '12 at 23:58
1:object>key>correct_value 2:object>key>null so on... – yowmamasita Sep 21 '12 at 00:05
In firebug are you seeing each call and the response? – Alex Reynolds Sep 21 '12 at 00:14
That blows my mind, we'll need to see more code or maybe try disabling ajax caching http://stackoverflow.com/a/735101/1130734 – Timm Sep 21 '12 at 00:15
What do you get if you run my_page.php directly? – shapeshifter Sep 21 '12 at 00:50
Try changing to a POST or add a random parameter - try to knock out any cache that might be playing up. Otherwise, as Petah said - more code to see what else could be going wrong. – Robbie Sep 21 '12 at 01:46

SQL query returns a null after first iteration

0 Answers0